| ramesh |
Posted: Feb 20, 2008 01:20:56 AM |
Total Post: 40
Joined: Aug, 2007
|
Hi,
I have some big table(50 millions of records) that are not partitioned in a production HP-UX Server with Oracle 9i database. I am thinking of partitioning them. Because there is not much time avaiable, I need to do it in as little time as possible. Please advince what is the best strategy to implement for an existing tables which does not have partitions which cannot used by export/import there is any another method to do this. Thanks in advance.
|
|
|
 Mohammed Taj |
| Posted: Feb 20, 2008 02:31:06 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
First you have to decide which partition method you want to use.
and there is so many sites and references on net for example.
http://www.google.ae/search?hl=en&q=oracle+table+partition&meta=
|
|
|
|
|
| ramesh_oss |
| Posted: Feb 20, 2008 02:53:13 AM | |
|
Total Post: 1
Joined: Feb, 2008
|
i know the solution and i know how to search ...
|
|
|
|
|
| Murtuja |
| Posted: Feb 20, 2008 04:34:16 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
DBMS_REDEFINITION is useful when table will go from a non-partitioned table to a partitioned table
http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_43.shtml#The%20DBMS_REDEFINITION%20PL/SQL%20Package
and @ramesh_oss
It's really rude behavior in forum.If you know anything then you can post it here. it is not a starting point of discussion. You may or may not agree with my arguments,but this won't change my point.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
