| Scripts [message #73588] |
Wed, 26 May 2004 07:22  |
arun
Messages: 67
Registered: January 2000
|
Member |
|
|
hi,
Can i export data from one database to another using scripts, if yes what are the steps invloved.
Any help is greatly appreciated
Arun.
|
|
|
|
| Re: Scripts [message #73601 is a reply to message #73588] |
Mon, 31 May 2004 06:04  |
Tak Tang
Messages: 142
Registered: May 2004
|
Senior Member |
|
|
If it was from one oracle database to another, I would set up a DATABASE LINK.
Alternatively, I would use SQL or PL/SQL to dump the data to a file . . .
http://asktom.oracle.com/~tkyte/flat/
. . . and then use SQL Loader (or External Tables in Oracle 9) to actually load the database.
If you are using Oracle 7, 8 or 9, and are not using LONGs or LOBs, you could use the COPY command in SQL*Plus. I think this has been deprecated in 10g.
Some third party tools (such as TOAD) have a feature to generate INSERT statements. These do work, but they are *terribly* slow.
Takmeister
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
