| Urgent Urgent ::: importing in diff tablespace [message #62540] |
Wed, 28 July 2004 02:44  |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
Dear friends,
When I am importing a dump file it is not importing to default tablespace of user.
Scenario:
Database -A Oracle-9i
User:imms -Default Table space for this user is "IMMS"
I have taken export of user imms.
Database-B Oracle-9i
create user new_imms identified by imms default tablespace users;
Tablespace in Database-B
IMMS
USERS
TEMP
SYSTEM.
Now Problem is when I am importing a dump in user new_imms
segment is imported in tablespace "IMMS" Instead of it's default
tablespace "USERS".
I know this is why happen bec's in my export file tablespace is "IMMS".
But I m Unable to find the solution.
so,kindly give solution for this prob.. as early as possible.
Thax In advance...
|
|
|
|
|
|
|
|
| Re: Urgent Urgent ::: importing in diff tablespace [message #62560 is a reply to message #62540] |
Thu, 29 July 2004 00:36  |
Norvin
Messages: 22
Registered: July 2001
|
Junior Member |
|
|
hi,
I'm gonna give my simple idea.
1. create a table and use your target tablespace.
create the table in two ways:
a. manually create the table on oracle prompt. ( i.e. identify every field, datatypes, table parameters )
b. create using imp user/password file=xxx.dmp tables=tableA rows=n. this option create the table in tablespace "imms", so you need to create the table manually using create table new_table .... tablespace <users>... as select * from old_table where 1 = 2;. in this way you eliminate the hassle of identifying all fields and its datatype. choose w/c is best applicable.
2. begin importing data.
since the table has been created, the next time you import you wont be facing this problem again.
Norvin/Philippines
|
|
|
|
|
|
| Re: Urgent Urgent ::: importing in diff tablespace [message #62866 is a reply to message #62540] |
Fri, 20 August 2004 06:50 |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
hi bhavin
im late in responding to you. i think by now you must have imported all the objects in the IMMS table space of database_B.
1.
you can moe all the objects from IMMS table space to USERS for example a table like this
alter table
move tablespace users ;
indexes can be rebuilt .
2.
use this imp command .
imp system/manager@database_b file=dumpfile.dmp fromuser=IMMS touser=NEW_IMMS
i think this will work .
if no then
see step 1.
with best wishes
balaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
