| Best practices for data transformation. [message #62723] |
Tue, 10 August 2004 22:49  |
Ach
Messages: 26
Registered: April 2004
|
Junior Member |
|
|
Hi all,
I found this ways to transfer data between two tables in two seperate schemas:
1.INSERT INTO dest_table SELECT * from source_table
2.first DROP TABLE dest_table and second CREATE TABLE dest_table as SELECT * from source_table
3.using COPY command in SQL*PLUS (but in one case I copy data with successfuly message and commit it but I could not see my records in destinition table!Any suggestions?)
4.Using imp and exp(This ways problem is: I define my destionition table in a specific table_space named TS1 but using this way dest table uses from source tables table_space named TS2.Should I use ALTER TABLE .... TABLE SPACE...for all my dest tables?Any better way?)
5.using EM->Change Manager->DB propogate
NOW MY QUESTION IS: which one of these ways is better in the case of performance and speed?
thank u for reading this long message!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
