Home » RDBMS Server » Server Administration » Data movement from one partition to another (10g)
Data movement from one partition to another [message #315475] Mon, 21 April 2008 11:58 Go to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
HI Everybody,

Please guide me in the scanario.

1. I have two schemas A and schema B.
2. Two tablespace T1 and T2.
3. one table data2007.

due to the space constarint i had to import data of oct 07, and nov 07 into 'A' schema and specified tablespace T1.

and imported dec 07 data into 'B' schema and tablespace specified tablepace t2.

Now i want to merge the data into one schema i.e schema 'A' and tablespace T1.

Please guide me.


Thanks for your time.

Regards,

Liam.
Re: Data movement from one partition to another [message #315485 is a reply to message #315475] Mon, 21 April 2008 13:02 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>due to the space constarint i had to import data of oct 07, and nov 07 into 'A' schema and specified tablespace T1.
>Now i want to merge the data into one schema i.e schema 'A' and tablespace T1.


What has changed & why will the data now fit in T1?
If there is now enough free space in T1, just import dec 07 data into 'A schema'.
Re: Data movement from one partition to another [message #315490 is a reply to message #315475] Mon, 21 April 2008 13:15 Go to previous messageGo to next message
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
Thanks for your response.

we have now added some space to T1 tablespace.

instead of using Imp again, can i use "as select * from B" using insert statement in A schema;

Please suggest.
Re: Data movement from one partition to another [message #315826 is a reply to message #315490] Tue, 22 April 2008 22:02 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
insert /*+append*/
into   a.data2007
select *
from   b.data2007


Ross Leishman
Previous Topic: Manage alertSID.log
Next Topic: Error creating spfile from pfile
Goto Forum:
  


Current Time: Tue Dec 06 08:28:37 CST 2016

Total time taken to generate the page: 0.17032 seconds