| copy table from one database to another [message #64310] |
Tue, 11 January 2005 01:59  |
Roland
Messages: 24
Registered: March 2002
|
Junior Member |
|
|
Hello everyone.
Can't anyone help with and scripts to copy and table from an oracle database on windows to another database install on an linux Operating system;
|
|
|
|
| Re: copy table from one database to another [message #64311 is a reply to message #64310] |
Tue, 11 January 2005 02:46  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Here are a couple of methods you can use:
1) Use the exp.exe utility to export the table on Windows, copy the dump file to your Linux machine (binary mode), and re-import. See the Utilities Users Guide for details.
2) Use a CTAS (CREATE TABLE ... AS SELECT ...) statement via a DB Link. See the SQL Reference Guide for details.
3) Use the SQL*Plus COPY Command. See the SQL*Plus manual for details.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
