Jul 25 2008, 03:01 PM
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..
Jul 25 2008, 03:05 PM
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.
Jul 25 2008, 04:10 PM
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?
Jul 25 2008, 04:28 PM
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?
Jul 26 2008, 09:18 AM
>> 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