OraFAQ Forum: Server Utilities » Export Full DB with no Tablespace

Home » RDBMS Server » Server Utilities » Export Full DB with no Tablespace (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Full DB with no Tablespace [message #397896]

Tue, 14 April 2009 08:03

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't.
But you can precreate your tablespaces before import.

Regards
Michel

Report message to a moderator

Re: Export Full DB with no Tablespace [message #397909 is a reply to message #397902]

Tue, 14 April 2009 08:35

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

Report message to a moderator