Home » RDBMS Server » Server Administration » Meta data for Table Partition (merged 2 CM) (oracle 12c Windows 2012)
Meta data for Table Partition (merged 2 CM) [message #669491] Wed, 25 April 2018 04:45 Go to next message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi All,

While importing a entire schema, table got imported but the TABLE PARTITION gone missing.

How to get rid of it.

Do we have option of getting metadata for only the TABLE PARTITION, so I can just apply them on the table.

Regards
M.Krish
Re: Meta data for Table Partition [message #669514 is a reply to message #669491] Thu, 26 April 2018 13:55 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
You can partition your non-partitioned table with DBMS_REDEFINITION or the ALTER TABLE... EXCHANGE PARTITION... syntax.

PS: If you export a partitioned table with Data Pump and you re-import it somewhere else, the table will remain partitioned (unless you imported into an existing non-partitioned table).
Re: Meta data for Table Partition [message #669621 is a reply to message #669514] Thu, 03 May 2018 08:18 Go to previous message
muthukrish104
Messages: 82
Registered: November 2017
Member
Hi Frank,

Thanks for the guidance, we will try this out.

Regards
M.Krish
Previous Topic: what is the file ORA_DUMMY_FILE.f in oracle?
Next Topic: ORA-01017 after restore to a test server
Goto Forum:
  


Current Time: Fri Mar 29 07:27:13 CDT 2024