Do you need to do it fast, or are you strapped for space ?
How much temporary space do you have for recreating
indexes ? How much hassle will it be to re-apply
privileges if you drop the original table ?
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
David YEUNG wrote in message <3ADFED5D.8578C3B8_at_ust.hk>...
>I have a number of tables growing quite large and I would like
>to convert them to partitioned tables. Could anyone tell me what
>is the best way to convert a normal table to a range partitioned
>table? Do I need to re-create the table using partition clauses
>and then re-load the data into it, or can I use the 'alter table ...'
>statement to do so?
>
>Thanks
>
>david
Received on Fri Apr 20 2001 - 14:30:13 CDT
