Home » RDBMS Server » Server Utilities » Export Full DB with no Tablespace (Oracle 9i)
Export Full DB with no Tablespace [message #397896] Tue, 14 April 2009 08:03 Go to next message
zanric
Messages: 6
Registered: April 2009
Junior Member
Creating the Export full DB file. is it included the creation of the Tablespaces?

HOw is it possible exclude the tablespace creation in the dmp file when i do the Export full DB?

[Updated on: Tue, 14 April 2009 08:11]

Report message to a moderator

Re: Export Full DB with no Tablespace [message #397902 is a reply to message #397896] Tue, 14 April 2009 08:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
But you can precreate your tablespaces before import.

Regards
Michel
Re: Export Full DB with no Tablespace [message #397909 is a reply to message #397902] Tue, 14 April 2009 08:35 Go to previous messageGo to next message
zanric
Messages: 6
Registered: April 2009
Junior Member
ok
but when i perform the Import utility,
selecting [show export file contents only], in the output file i see also the statement to create the tablespace like
CREATE TABLESPACE etc etc
Re: Export Full DB with no Tablespace [message #397912 is a reply to message #397896] Tue, 14 April 2009 08:47 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
so use IGNORE=YES
Re: Export Full DB with no Tablespace [message #397915 is a reply to message #397912] Tue, 14 April 2009 08:50 Go to previous message
zanric
Messages: 6
Registered: April 2009
Junior Member
Ok
thnks
Previous Topic: Import a 10g dmp file from 9i
Next Topic: DBMS_DATAPUMP - EXPORT, TRANSPORTABLE - missing info
Goto Forum:
  


Current Time: Sun Dec 04 08:40:49 CST 2016

Total time taken to generate the page: 0.11187 seconds