OraFAQ Forum: Server Administration » create as select

Home » RDBMS Server » Server Administration » create as select (Oracle 9i on HP-UX)

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

create as select [message #460648]

Sun, 13 June 2010 18:12

caprikar
Messages: 226
Registered: March 2007

Senior Member

I have oracle 9i database in which I have a table say Table A with 300 million records and i want to partition this table. If i create new partition table Table B and do insert into table B as select * from table A, approximately how much time it will take?
Thanks

Report message to a moderator

Re: create as select [message #460649 is a reply to message #460648]

Sun, 13 June 2010 18:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> how much time it will take?
It depends & since we don't have your hardware or environment, only YOU can determine by actual benchmark testing.

Report message to a moderator

Re: create as select [message #460672 is a reply to message #460648]

Mon, 14 June 2010 01:36

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use dbms_redefinition and do in online.

Regards
Michel

[Updated on: Mon, 14 June 2010 01:39]

Report message to a moderator

Previous Topic:	db creation ctl error
Next Topic:	11g upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 19 02:52:34 CDT 2025