-
Hi,
I have to break a given big table into 2 partitions. So I would like to know from you, if it is possible to partition the existing table to span into 2 tablespaces. If possible, please give me the script for the
Alter table
Thanks in advance
Badrinath
-
No, a table is a table and a partitioned table is a partitioned table. I would suggest:
1. create a partitioned table with the same structure
[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/partiti.htm#1931[/url]
2. exchange your table with a partition of the table
[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem2a.htm#2056713[/url]
[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c09parti.htm#451069[/url]
Jeff Hunter
-
Hi,
U can't partition an existing table which has no partitions at all. U can only alter already existing partitioned table.
with regards
Prasanna S
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|