how do transfer the data from one db to another [message #49806] |
Mon, 11 February 2002 05:02 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
I have 2 database(db1 and db2).
in db1 i have following datafiles ...
df1,df2,df3,df4 & df5
In db2 i have only 3 datafiles
df1,df2 & df3
Without creating additional datafiles which are there in db1 on the server db2,how to port the database through export and import.
anyhelp is appreciated
|
|
|
Re: how do transfer the data from one db to another [message #49808 is a reply to message #49806] |
Mon, 11 February 2002 05:24 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
You mentioned 2 databases with diff data files.
With export/import, the name of the TABLESPACE matters. Make sure the tablespace name is the same. How many data files a TS has is irrelevant, but the total file size may matter.
Eg.
db1 has ts1 (df1 500MB, df2 500MB)
db2 has ts1 (df3 1000MB)
You can easily export in db1 and import in db2 without any problems. Both the TS has the same name and same total size.
Hope you got the picture.
|
|
|
Re: how do transfer the data from one db to another [message #49810 is a reply to message #49808] |
Mon, 11 February 2002 07:29 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
If there are different tablespaces in both db.
like in db1 --i have 3 tablespaces tbs1,tbs2 and tbs3
in db2 i have only 2 tablespace tbs1 and tbs2.
So,is there any possibility of transfering the data from the db1 to db2 without creating the tablespace 3 called tbs3
|
|
|
|