How do I copy just the data from one db to another? [message #74547] |
Wed, 05 January 2005 04:38 |
Patrick Ferguson
Messages: 4 Registered: January 2005
|
Junior Member |
|
|
Thanks for taking a look. I'm between a rock and a hard place.
I know how to do a full database copy, that's pretty easy. And I know how to create control files and load them via sql loader. But my problem is I need to find a way to write a script which will create control files out of all of the tables in a specific database. Then I need a script which will turn around and load them all into another database. I plan on dropping the constraints on the destination database so the load will go quickly and smoothly. Is this easy to do and I just can't figure it out? Please someone help me, I am in a seriously pressure situation where I need this done quickly. I will name my first born after you if you can help me solve this problem.
Posting on here is fine, but if you could also e-mail me directly at fergp25@gmail.com would help me out a ton.
Thanks,
Patrick
|
|
|
|
Re: How do I copy just the data from one db to another? [message #74550 is a reply to message #74548] |
Wed, 05 January 2005 06:20 |
Patrick Ferguson
Messages: 4 Registered: January 2005
|
Junior Member |
|
|
Okay, I looked at the export and import stuff, seems to be what I need, but when I try to execute a simple export like this, it fails with a table not found and i KNOW the table exists. Is there something wrong with my syntax??
C:>exp userid/passwd@dbname tables=SET_CHANGE_TYPE_RFT file=set_ecode_ref.dmp
Export: Release 9.0.1.3.1 - Production on Wed Jan 5 10:25:25 2005
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
|
|
|
|
|