| Copying Tables between IDs [message #372645] |
Thu, 01 March 2001 13:39  |
joshua
Messages: 3
Registered: March 2001
|
Junior Member |
|
|
|
With project/employee turnover I need to copy all the tables from 1 ID to another. Does anyone know how to script this? I am using SQL Nav to access Oracle on a Unix server(FYI).
|
|
|
|
| Re: Copying Tables between IDs [message #372646 is a reply to message #372645] |
Thu, 01 March 2001 14:09  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
3 ways are:
1.) export that table from the source and import on the target (exp scott/tiger tables=(emp); and imp scott/tiger... use imp help=y for help)
2.) COPY FROM SCOTT/TIGER@BOSTONDB -
> TO TODD/FOX@CHICAGODB -
> CREATE NEWDEPT (DNUMBER, DNAME, CITY)-
> USING SELECT * FROM DEPT;
You can reportedely loose data precision with this (maybe this used to be true). The command is made to copy to non-oracle db's.
3) the easy way is:
create table t1 as (select * from t1@remote_db);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
