469,366 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

How to get partition script for a table ?

Hello,

I need to get partition script for a table.
As we get create table script , i need a table's Partition script.
please help me with your expertise.
Sep 17 '07 #1
7 18716
amitpatel66
2,367 Expert 2GB
Hello,

I need to get partition script for a table.
As we get create table script , i need a table's Partition script.
please help me with your expertise.
Find about creating partition tables here and here
Sep 17 '07 #2
Find about creating partition tables here and here

Hello Amit,

Thanks for the informative reply.
Is it possible to get table partition script ?
If Yes, how can i get it ?

because i have not created the table partition, and i need the table partition script to create it some other db.
please send me your thoughts.
Sep 17 '07 #3
amitpatel66
2,367 Expert 2GB
Hello Amit,

Thanks for the informative reply.
Is it possible to get table partition script ?
If Yes, how can i get it ?

because i have not created the table partition, and i need the table partition script to create it some other db.
please send me your thoughts.
You can make use of the logic that is given in the links that I have provided you in the pervious POST to create a table with partitions
Sep 17 '07 #4
You can make use of the logic that is given in the links that I have provided you in the pervious POST to create a table with partitions
Thanks for the reply. I did not get answers to my questions.
It's okay..!! i'l find it out.
Sep 17 '07 #5
amitpatel66
2,367 Expert 2GB
Thanks for the reply. I did not get answers to my questions.
It's okay..!! i'l find it out.
Please be more specific to your requirement.
You want to create a table with partition?
or
you want to partition an existing table? (If this is the requirement, then you CANNOT partition the existing table)
Sep 17 '07 #6
Please be more specific to your requirement.
You want to create a table with partition?
or
you want to partition an existing table? (If this is the requirement, then you CANNOT partition the existing table)

OK, i'l be more specific.
I already have a table with partition.
now, i want to get only the partition script of the table. Is it possible?
Sep 17 '07 #7
Saii
145 Expert 100+
If you work on some IDE like Toad, you can eaily get the script from there.

Else you can use dbms_metadata package.

select dbms_metadata.get_ddl('TABLE','<tab-name>','<schema>') from dual;

Just check if it works for partitioned table too.
Hope that helps!!!
Sep 17 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by sameer_deshpande | last post: by
25 posts views Thread by John Salerno | last post: by
1 post views Thread by Laurence | last post: by
1 post views Thread by rajanbabu23 | last post: by
3 posts views Thread by nbajrach | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.