How Can I move/copy the data in a scenario like this
From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 19 Mar 2003 12:59:13 -0800
Message-ID: <25c1993e.0303191259.7463f5b0_at_posting.google.com>
Date: 19 Mar 2003 12:59:13 -0800
Message-ID: <25c1993e.0303191259.7463f5b0_at_posting.google.com>
Hi,
I had a table called MyTable created originally in 'users' tablespace. This had 20,000 rows of data. In the next version, I modified my install_upgrade and made MyTable as a part of new table space 'test'. Now 'MyTable2' has zero rows. How can i move or copy data from MyTable1 (from previous schema ) to current schema.
MyTable is a synonym that points to the latest schema version of MyTable
-hope i was clear,
thx,
Sri
Received on Wed Mar 19 2003 - 21:59:13 CET