OraFAQ Forum: Server Administration » Data movement from one partition to another

Home » RDBMS Server » Server Administration » Data movement from one partition to another (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data movement from one partition to another [message #315475]

Mon, 21 April 2008 11:58

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.

Report message to a moderator

Re: Data movement from one partition to another [message #315485 is a reply to message #315475]

Mon, 21 April 2008 13:02

BlackSwan
Messages: 26766
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'.

Report message to a moderator

Re: Data movement from one partition to another [message #315490 is a reply to message #315475]

Mon, 21 April 2008 13:15

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.

Report message to a moderator

Re: Data movement from one partition to another [message #315826 is a reply to message #315490]

Tue, 22 April 2008 22:02

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

insert /*+append*/
into   a.data2007
select *
from   b.data2007

Ross Leishman

Report message to a moderator

Previous Topic:	Manage alertSID.log
Next Topic:	Error creating spfile from pfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 21:49:38 CST 2024