Home » RDBMS Server » Server Utilities » dp import with tablespaces (oracle 10g)
dp import with tablespaces [message #391134] Wed, 11 March 2009 03:38 Go to next message
ora_baby
Messages: 89
Registered: May 2008
Member
hi

i have a dump file for schema "SH1" with many (30) tablespaces.
i want importing "SH1" to another database. But than i make import i have error ORA-00959: tablespace 'tbs1' does not exist.

a question is:
- tablespaces of "SH1" arent created - why?
- i must create all tablespaces manually?

do another way exist?
Re: dp import with tablespaces [message #391141 is a reply to message #391134] Wed, 11 March 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- because tablespace is not owned by SH1 so is not part of export
- yes

Regards
Michel
icon9.gif  Re: dp import with tablespaces [message #391184 is a reply to message #391141] Wed, 11 March 2009 07:03 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
manually?
may be there are another ways, aren't there?
Re: dp import with tablespaces [message #391190 is a reply to message #391184] Wed, 11 March 2009 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Manually, yes.
Extract the DDL for the tablespaces from source database (see dbms_metadata).

Regards
Michel
Re: dp import with tablespaces [message #391197 is a reply to message #391190] Wed, 11 March 2009 07:32 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>> But than i make import i have error ORA-00959: tablespace 'tbs1' does not exist.

Yes you need to create tablespace in target database.

If you don't want to create any tablespace in target database.

Then revoke "Resource" Role from your user. Only give it "Connect" Role to user.

Data's goes to import default tablespace.

Babu
Previous Topic: sql loader Problem
Next Topic: ORA-01555..during export
Goto Forum:
  


Current Time: Sun Dec 04 00:20:49 CST 2016

Total time taken to generate the page: 0.05536 seconds