Home » RDBMS Server » Server Utilities » error in importing (oracle 10g,linux)
error in importing [message #462069] Tue, 22 June 2010 12:05 Go to next message
babicool1
Messages: 1
Registered: June 2010
Junior Member
i have a problem in importing the table,

i try to export a table from a database(default tablespace is system) to another database(default tablespace users),my table is expoted sucessfully
after importing the table when i check the destination using dba_tables it will reside in system tablespace only i can't understand why it happend.
please give a solution to my problem...........

Report message to a moderator

Re: error in importing [message #462070 is a reply to message #462069] Tue, 22 June 2010 12:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>please give a solution to my problem...........
manually CREATE TABLE prior to import in the desired (new) tablespace
then on import command line specify IGNORE=YES

Report message to a moderator

Re: error in importing [message #462089 is a reply to message #462069] Tue, 22 June 2010 13:11 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
you can also try revoking privileges on system tablespace in the new database from this user.

Report message to a moderator

Re: error in importing [message #462215 is a reply to message #462089] Wed, 23 June 2010 03:56 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd say that should be done regardless.

Report message to a moderator

Re: error in importing [message #462225 is a reply to message #462215] Wed, 23 June 2010 04:21 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... and so UNLIMITED TABLESPACE should not be granted to anyone.

Regards
Michel

Report message to a moderator

Previous Topic: IMP-00041: Warning: object created with compilation warnings
Next Topic: Datapump
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 02:27:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.