OraFAQ Forum: Backup & Recovery » issue about imp command

Home » RDBMS Server » Backup & Recovery » issue about imp command

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

issue about imp command [message #231488]

Tue, 17 April 2007 04:58

kaisy.lin
Messages: 12
Registered: April 2007

Junior Member

i got a dump file ,i created a file by using command imp show=y to find out that there were 3 tablespaces need to build to import that database.

but i didn't create all the tabespaces accordingly , after import command issuing , all the tables were imported correctly .

for example
table a belong to tablespace a
table b belong to tablespace b

i just created tablespace a .
how come both table a and table b are imported ?

Report message to a moderator

Re: issue about imp command [message #231494 is a reply to message #231488]

Tue, 17 April 2007 05:15

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Because your user has tablespace a as default tablespace and if imp can't import in the target tablespace it imports in the default one.

Regards
Michel

Report message to a moderator

Re: issue about imp command [message #231527 is a reply to message #231494]

Tue, 17 April 2007 07:16

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And the owner may be have RESOURCE role enabled

Report message to a moderator

Re: issue about imp command [message #231558 is a reply to message #231527]

Tue, 17 April 2007 09:09

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.
Quota on tablespace is sufficient, no need of the UNLIMITED TABLESPACE privilege (which comes with RESOURCE role).

Regards
Michel

Report message to a moderator

Re: issue about imp command [message #231574 is a reply to message #231558]

Tue, 17 April 2007 10:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I was referring to something else.
RESOURCE will also let the user to write to ANY tablespace even without explicit quota.

Report message to a moderator

Re: issue about imp command [message #231578 is a reply to message #231574]

Tue, 17 April 2007 10:28

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Which is useless here as there is only 1 tablespace ("a" in the exemple given).

Regards
Michel

Report message to a moderator

Re: issue about imp command [message #231648 is a reply to message #231488]

Tue, 17 April 2007 21:40

kaisy.lin
Messages: 12
Registered: April 2007

Junior Member

i issued the sql "select * from user_role_privs" to find out that there are three granted role for the user: CONNECT ,DBA, EFSNORL

there is no role like "RESOURCE" that has been granted for the user .i was wondering if the dba role is enough for all the operation.or , maybe ,the users tablespace is used for all the object.

sorry , i am not so good at english , i am chinese ,so please forgive my mistake about expression.

Report message to a moderator