Help - Search - Members - Calendar
Full Version: databse export
Oracle DBA Forums > Oracle > Oracle Forum
odibat
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
aussie_dba
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.
odibat
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
SteveC
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?
burleson
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.