| Partition source [message #148767] |
Mon, 28 November 2005 00:51  |
darsh_v
Messages: 16
Registered: February 2005
Location: hyderabad
|
Junior Member |
|
|
Hi,
How can we see the source of the partition on a table. I imported old schema dump to new schema but the partitions are not imported(though tables on which partitions was done are imported).. How can i do partition on the tables in new schema
as it was done in the old schema.
Rgds,
Darshan
|
|
|
|
| Re: Partition source [message #149035 is a reply to message #148767] |
Tue, 29 November 2005 15:25  |
skgoel
Messages: 16
Registered: November 2005
|
Junior Member |
|
|
Darshan,
Did you try creating the tables with partitions in the new schema using the DDL from the old schema, and then executing
insert into new_partitioned_table
select * from new_nonpartitioned_table
This will duplicate the data and may require extra space.
You can add condition to the insert clause to limit the data inserted and then delete the inserted data fom the old table
Or, you could create an empty partitioned table in the new schema and import data into it using the dump file (generated by exp)
etc ...
Shakti
http://www.impact-sol.com
Developers of Guggi Oracle - Tool for DBAs and Developers
|
|
|
|
| Re: Partition source [message #151968 is a reply to message #149035] |
Tue, 20 December 2005 02:35 |
darsh_v
Messages: 16
Registered: February 2005
Location: hyderabad
|
Junior Member |
|
|
Hi Shakti,
Thnx for the reply. Visited this side after many days..
Just for the info ..we can see the sql to create the table from the dump file itself.
type in the command prompt -
imp username/password show=y full=y file=<dump file path> log=<log file path>
You can see the sql in the log file.
Regards,
Darshan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
