| Kaiz |
Posted: Mar 31, 2008 02:47:22 AM |
Total Post: 104
Joined: Sep, 2007
|
Dear Friends,
how to export one object say one table from one schema to another in the same database.... command line way...
Thanks & Regards... |
|
|
 Avnish |
| Posted: Mar 31, 2008 05:33:05 AM |  |
|
Total Post: 154
Joined: Dec, 2007
|
To Export:
EXP SCHEMA1/PASSWORD FILE=PATH TABLES=TABLENAME LOG=PATH_FOR_LOG_FILE
To Import:
IMP SYSTEM/MANAGER FILE=PATH FROMUSER=SCHEMA1 TOUSER=SCHEMA2 LOG=PATH FOR LOG FILE
If your OS from which you importing this table is LINUX then,add "STATISTICS=NONE" option in Import command.
|
|
|
|
|
| Mohammed Taj |
| Posted: Mar 31, 2008 09:35:01 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
You can also use CTAS ( CREATE TABLE ... AS SELECT ) statement.
|
|
|
|
|
| Kaiz |
| Posted: Apr 01, 2008 02:49:03 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Thanks to both of you , the sec. answer is very interesting...
With Regards...
|
|
|
|
|
| Avnish |
| Posted: Apr 02, 2008 04:30:10 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
CTAS is the fastest way to create a table regrading reducing I/O activity.
& ofcourse second option you'll expect from a expert....DBA
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
