OraFAQ Forum: Server Administration » Meta data for Table Partition (merged 2 CM)

Home » RDBMS Server » Server Administration » Meta data for Table Partition (merged 2 CM) (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Meta data for Table Partition (merged 2 CM) [message #669491]

Wed, 25 April 2018 04:45

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

Report message to a moderator

Re: Meta data for Table Partition [message #669514 is a reply to message #669491]

Thu, 26 April 2018 13:55

Frank Naude
Messages: 4581
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).

Report message to a moderator

Re: Meta data for Table Partition [message #669621 is a reply to message #669514]

Thu, 03 May 2018 08:18

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi Frank,

Thanks for the guidance, we will try this out.

Regards
M.Krish

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 11:53:03 CST 2024