Home » RDBMS Server » Server Utilities » Importing tables in the default tablespace of a user
Importing tables in the default tablespace of a user [message #72658] Tue, 19 August 2003 05:56 Go to next message
Kumar Devendra
Messages: 4
Registered: June 2002
Junior Member
I have exported full user in a file *.dmp of a particular user(suppose 'x').Tables of the user 'x' are stored in tablespace 'ts_x'.I want to import it in other user (say 'y') whose default tablespace is 'ts_y'.But while importing it is storing all the tables in 'ts_x' for the tables of 'y'.I want to import in the tablespace 'ts_y'.Please help me what i have to do ?
Re: Importing tables in the default tablespace of a user [message #72660 is a reply to message #72658] Tue, 19 August 2003 06:05 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. create a tablespace ts_y.
2. assign it to user Y( make it default for Y).
--now do import like
3. imp dba/password fromuser=x touser=y file=myfile.dmp
-- NOTE:
-- this will create all the tables in ts_y
-- if there are any indexes, still in someother 
-- tablespaces that are owned by X, it will recreate the
-- indexes in that tablespace only.
-- so, use indexes=y to ignore the indexes ( indexes by primary keys, wont be ignored) and
-- recreate the indexes manually 
-- or
-- let the indexes be created in ts_X. later u can move them to ts_y

Previous Topic: SQL Loader Parameter setting
Next Topic: into table clause Syntax
Goto Forum:
  


Current Time: Tue May 28 21:07:32 CDT 2024