Hi
If I am doing export usind the data pump mode=full, does that include all the tablespaces,indexes, ...
In other words, Can I drop the databse that I exported and recover it with import?
what should I keep to be able to retrieve the entire databse..
Thanks

Export (data pump) is a "logical" export of table row data:

"does that include all the tablespaces"

No. You need to re-create those before import.

"Can I drop the databse that I exported and recover it with import?"

Yes, so long as there has been no update activity since the export.

So let us assume that I did full export.
Then I delete all the tablespaces with the tables and indexess..(delete the databse instance).
To rerive the previous databse I need to do the following:
1. create a databse instance.
2. create the tablespaces with the datafiles.
3. use full import.
Is that right? am I missing any step?
Should I create the tablespace and the data files with the same name and location as in the previous database?
Thanks

Data doesn't care about physical location. That was the whole idea behind Codd's paper. Have you read that?

http://www.seas.upenn.edu/~zives/03f/cis550/codd.pdf

What were the results you got when testing this?

Hi,

>> Can I drop the databse that I exported and recover it with import?

In addition to the export, you will want to punch-off the ablespace defintions with dbms_netadata.

Then, pre-create the tablespace and start the import:

http://www.dba-oracle.com/art_builder_get_schema_syntax.htm