OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » partition of table

Fri, 20 April 2007 07:01

kishore_dba
Messages: 21
Registered: March 2007
Location: HYDERABAD

Junior Member

hi,
can we create partition after creating table.
regards,
kishore.

Fri, 20 April 2007 07:04

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If the table is already partitioned, yes; if it is not, no.

Regards
Michel

Mon, 23 April 2007 21:35

sweeann
Messages: 7
Registered: April 2007

Junior Member

kishore_dba wrote on Fri, 20 April 2007 20:01

hi,
can we create partition after creating table.
regards,
kishore.

Not from me, but you can try reading this article to partition an existing table.

http://www.oracle-base.com/articles/misc/PartitioningAnExistingTable.php

Previous Topic:	ORA-12518 10g listener to 8i DB's
Next Topic:	migration from 8.0 to 9i

Goto Forum:

]

Current Time: Fri Sep 20 00:29:29 CDT 2024