OraFAQ Forum: Server Utilities » dp import with tablespaces

Home » RDBMS Server » Server Utilities » dp import with tablespaces (oracle 10g)

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

dp import with tablespaces [message #391134]

Wed, 11 March 2009 03:38

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?

Report message to a moderator

Re: dp import with tablespaces [message #391141 is a reply to message #391134]

Wed, 11 March 2009 03:56

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

Senior Member
Account Moderator

- because tablespace is not owned by SH1 so is not part of export
- yes

Regards
Michel

Report message to a moderator

Re: dp import with tablespaces [message #391184 is a reply to message #391141]

Wed, 11 March 2009 07:03

ora_baby
Messages: 89
Registered: May 2008

Member

manually?
may be there are another ways, aren't there?

Report message to a moderator

Re: dp import with tablespaces [message #391190 is a reply to message #391184]

Wed, 11 March 2009 07:22

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

Senior Member
Account Moderator

Manually, yes.
Extract the DDL for the tablespaces from source database (see dbms_metadata).

Regards
Michel

Report message to a moderator

Re: dp import with tablespaces [message #391197 is a reply to message #391190]

Wed, 11 March 2009 07:32

babuknb
Messages: 1736
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 19:46:34 CST 2024