Home » RDBMS Server » Backup & Recovery » Importing partition of a table to a different tablespace
Importing partition of a table to a different tablespace [message #239848] Wed, 23 May 2007 08:01 Go to next message
pradeep.ramana
Messages: 12
Registered: March 2007
Junior Member
Hi All,

I've export backup of a table partitioned on range, i want to import particular partition to a tablespace different from tablespace which i exported from

I don't want the same table space to be used while importing

Please can anyone helpus in it as we would be doing it live application?

Thanks in advance
Re: Importing partition of a table to a different tablespace [message #239851 is a reply to message #239848] Wed, 23 May 2007 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Precreate the partition in the tablespace you want.

Regards
Michel
Re: Importing partition of a table to a different tablespace [message #239853 is a reply to message #239851] Wed, 23 May 2007 08:16 Go to previous messageGo to next message
pradeep.ramana
Messages: 12
Registered: March 2007
Junior Member
Thanks for the reply,

Can you explain it in bit detail?
Re: Importing partition of a table to a different tablespace [message #239859 is a reply to message #239853] Wed, 23 May 2007 08:24 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create the table and partitions in the tablespace(s) you want before executing imp.

Regards
Michel
Previous Topic: Can RMAN specifically delete obsolete archivelogs?
Next Topic: RMAN Question
Goto Forum:
  


Current Time: Sat Dec 03 03:50:15 CST 2016

Total time taken to generate the page: 0.10574 seconds