Home » RDBMS Server » Server Administration » Get back partition data after dropping partition (10.2)
Get back partition data after dropping partition [message #354976] Wed, 22 October 2008 01:58 Go to next message
Bangla
Messages: 49
Registered: August 2008
Member
I had a partition over a table, date range support
1/1/07
1/2/07
1/3/07
1/4/07
1/5/07
Now I took dump of partition 1/2/07 and then I dropped the partition. Now I want to put back my data into partition 1/2/07. How I can do that?
Re: Get back partition data after dropping partition [message #354986 is a reply to message #354976] Wed, 22 October 2008 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Recreate the partition and import.

Regards
Michel
Re: Get back partition data after dropping partition [message #355000 is a reply to message #354976] Wed, 22 October 2008 03:11 Go to previous messageGo to next message
Bangla
Messages: 49
Registered: August 2008
Member
While importing,
SQL> !impdp tables=ban:P200805 content=data_only

Import: Release 10.2.0.1.0 - Production on Wednesday, 22 October, 2008 4:09:12

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Username: ba
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "BA"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "BA"."SYS_IMPORT_TABLE_01":  ban/******** tables=ban:P200805 content=data_only
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31696: unable to export/import TABLE_DATA:"BA"."BAN":"P200805" using client specified AUTOMATIC method
Job "BA"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 04:09:16
Re: Get back partition data after dropping partition [message #355012 is a reply to message #355000] Wed, 22 October 2008 03:56 Go to previous message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-31696: unable to export/import %s using client specified %s method
 *Cause:  Table attributes prevent client specified method for exporting
          or importing data.
 *Action: Use default 'DATA_ACCESS' parameter value.

Regards
Michel
Previous Topic: Oracle logging
Next Topic: Connecting MAPICS from Oracle Database
Goto Forum:
  


Current Time: Mon Nov 11 01:16:58 CST 2024