OraFAQ Forum: Backup & Recovery » Importing partition of a table to a different tablespace

Home » RDBMS Server » Backup & Recovery » Importing partition of a table to a different tablespace

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

Importing partition of a table to a different tablespace [message #239848]

Wed, 23 May 2007 08:01

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

Report message to a moderator

Re: Importing partition of a table to a different tablespace [message #239851 is a reply to message #239848]

Wed, 23 May 2007 08:09

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Precreate the partition in the tablespace you want.

Regards
Michel

Report message to a moderator

Re: Importing partition of a table to a different tablespace [message #239853 is a reply to message #239851]

Wed, 23 May 2007 08:16

pradeep.ramana
Messages: 12
Registered: March 2007

Junior Member

Thanks for the reply,

Can you explain it in bit detail?

Report message to a moderator

Re: Importing partition of a table to a different tablespace [message #239859 is a reply to message #239853]

Wed, 23 May 2007 08:24

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create the table and partitions in the tablespace(s) you want before executing imp.

Regards
Michel

Report message to a moderator

Previous Topic:	Can RMAN specifically delete obsolete archivelogs?
Next Topic:	RMAN Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 18:31:05 CST 2024