| moving database using exp/imp [message #476479] |
Thu, 23 September 2010 09:40  |
enjay
Messages: 15
Registered: September 2010
|
Junior Member |
|
|
Hello every one,
I need to move database ORCL into our existing central database CNTR (both are on same OS and oracle version)
I started exp each schema from ORCL and imp in CNTR.
But there is one schema EXMP in database ORCL which also exists in CNTR database with same tables, indexes . The data under schema EXMP in ORCL should be added to schema EXMP in CNTR.
How can I do this?
Your suggestions will be helpful.
Thanks,
enjay
|
|
|
|
|
|
| Re: moving database using exp/imp [message #476483 is a reply to message #476480] |
Thu, 23 September 2010 10:10  |
enjay
Messages: 15
Registered: September 2010
|
Junior Member |
|
|
Thank you Mahesh for you reply.
So what would be the best way to do this job.
Schema EXMP contain all the details regarding company id and users in both the databases(tables like company_id, company_users).
Since ORCL in now moved into CNTR database.
Now the EXMP should contain all the detail of both ORCL and CNTR. I should not create two separate tables under EXMP.
Thanks,
enjay
|
|
|
|
|
|
| Re: moving database using exp/imp [message #476499 is a reply to message #476492] |
Thu, 23 September 2010 11:03 |
enjay
Messages: 15
Registered: September 2010
|
Junior Member |
|
|
Mahesh,
"By default, imp will try to append the data, if the table already exists.
If there is a constraint violation, the data will be rejected by table.
Else, you will get duplicated data."
What kind of constraint violation can be expected?
When EXMP schema contains company_id table in CNTR database.
CNTR: imp username/passwd file=exp.dmp fromuser=EXMP touser=EXMP rows=n
Then the data will be appended to table company_id in CNTR database without any corruption to the existing data.
Please correct me if I am wrong.
Thanks.
|
|
|
|
|
|
| Re: moving database using exp/imp [message #476512 is a reply to message #476500] |
Thu, 23 September 2010 11:44 |
enjay
Messages: 15
Registered: September 2010
|
Junior Member |
|
|
Mahesh,
I need to move the export dump file from my remote server to local server. I heard that I need to FTP it in binary format. Both the servers are on Windows 2003 and Can I use WINSCP software (does WINSCP move the dump file in binary format) Or else Is there any other efficient way to move?
Thanks
|
|
|
|
|
|
| Re: moving database using exp/imp [message #476523 is a reply to message #476499] |
Thu, 23 September 2010 12:58 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
enjay wrote on Thu, 23 September 2010 12:03Mahesh,
"By default, imp will try to append the data, if the table already exists.
If there is a constraint violation, the data will be rejected by table.
Else, you will get duplicated data."
What kind of constraint violation can be expected?
One for example would be a unique ID in a table that will have the same value is both databases. We really have no idea as you know your data, you know your table structures. I would NOT just "try" to import and "see what happens."
You'll end up spending days just trying to fix the mess you created.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
