Home » RDBMS Server » Backup & Recovery » issue about imp command
issue about imp command [message #231488] Tue, 17 April 2007 04:58 Go to next message
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 ?
Re: issue about imp command [message #231494 is a reply to message #231488] Tue, 17 April 2007 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
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
Re: issue about imp command [message #231527 is a reply to message #231494] Tue, 17 April 2007 07:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And the owner may be have RESOURCE role enabled
Re: issue about imp command [message #231558 is a reply to message #231527] Tue, 17 April 2007 09:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
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
Re: issue about imp command [message #231574 is a reply to message #231558] Tue, 17 April 2007 10:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: issue about imp command [message #231578 is a reply to message #231574] Tue, 17 April 2007 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
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
Re: issue about imp command [message #231648 is a reply to message #231488] Tue, 17 April 2007 21:40 Go to previous messageGo to next message
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.
Re: issue about imp command [message #231660 is a reply to message #231648] Tue, 17 April 2007 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA role contains all what is in CONNECT and RESOURCE roles.

Regards
Michel
Re: issue about imp command [message #231663 is a reply to message #231488] Tue, 17 April 2007 23:40 Go to previous message
kaisy.lin
Messages: 12
Registered: April 2007
Junior Member
i got it , thank all for the reply , i really appricate it .
Razz
Previous Topic: how to get increment data from oracle to sqlserver2005?
Next Topic: wired issue
Goto Forum:
  


Current Time: Thu Dec 08 03:56:20 CST 2016

Total time taken to generate the page: 0.17693 seconds