OraFAQ Forum: Server Utilities » changing tablespace during import

Home » RDBMS Server » Server Utilities » changing tablespace during import (oracle 9i , solaris)

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

changing tablespace during import [message #378452]

Tue, 30 December 2008 08:27

koff10
Messages: 58
Registered: December 2006
Location: france

Member

Hi all,
I'm trying to import datafile based on tablespace A
to user where default tablespace is B .
But after import, the destination user get data on tablespace A instead of tablespace B
how can I do to keep data on tablespace B for my destination user
Thanks all
koff

Report message to a moderator

Re: changing tablespace during import [message #378462 is a reply to message #378452]

Tue, 30 December 2008 09:17

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

Senior Member
Account Moderator

May be the resource role is been granted to for destination user.
If granted, it would allow the user to write to any available tablespace.
During Import, the table definitions are read.
If the same tablespace exists in destination also, then the tables will be created in same tablespace.
So, revoke resource role, make only tablespace B as default for destination user with unlimited/limited quota and do the import.
If required, grant resource again after import.

Report message to a moderator

Re: changing tablespace during import [message #378474 is a reply to message #378462]

Tue, 30 December 2008 10:00

koff10
Messages: 58
Registered: December 2006
Location: france

Member

thanks for the solution
koff

Report message to a moderator

Previous Topic:	IMp-00010 during export
Next Topic:	SQL Loader - extra field in data file, but need to use its value for another field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:23:37 CST 2024