OraFAQ Forum: SQL & PL/SQL » Table partitioning & Saving Partition to different database.

Home » SQL & PL/SQL » SQL & PL/SQL » Table partitioning & Saving Partition to different database.

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

Table partitioning & Saving Partition to different database. [message #629622]

Fri, 12 December 2014 08:41

raj_te
Messages: 46
Registered: August 2013
Location: INDIA

Member

Can we save a partition of a table created on a database server to another database server. Lets say I have a database A on X server having table Z and i partitioned the table Z by range.
Now is it possible to save one of the partition of table Z to another separate database K on M server. Is it possible to do.
If yes kindly let me know how to fetch data from that partition.

Regards,
Raj

[Updated on: Fri, 12 December 2014 08:43]

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629623 is a reply to message #629622]

Fri, 12 December 2014 08:45

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

If the partition reside in own tablespace can be done using transportable tablespace.

[Updated on: Fri, 12 December 2014 10:20] by Moderator

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629624 is a reply to message #629623]

Fri, 12 December 2014 09:10

raj_te
Messages: 46
Registered: August 2013
Location: INDIA

Member

Am aware that we can move partitions of a table to different tablespace within a database on a server. What about moving table partitions to another database on some other server.

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629625 is a reply to message #629624]

Fri, 12 December 2014 09:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

please proceed to do so

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629626 is a reply to message #629623]

Fri, 12 December 2014 09:27

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

LKBrwn_DBA wrote on Fri, 12 December 2014 14:45

If the partition reside in own tablespace can be done using transportable tablespace.

Are you sure of this? The tablespace(s) that you transport are meant to be "self-contained", which would not be the case if the tablespace set doesn't include all partitions. There is the dbms_tts.isselfcontained procedure to check this.

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629627 is a reply to message #629625]

Fri, 12 December 2014 09:34

raj_te
Messages: 46
Registered: August 2013
Location: INDIA

Member

@BlackSwan ..Thanks ,,,Will proceed ,,,You need not have to worry much..Enjoy your life.

[Updated on: Fri, 12 December 2014 09:35]

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629628 is a reply to message #629624]

Fri, 12 December 2014 10:22

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you still want the partition moved to another database to be part of the original table, no you can't.

Report message to a moderator

Re: Table partitioning & Saving Partition to different database. [message #629639 is a reply to message #629628]

Fri, 12 December 2014 16:30

Bill B
Messages: 1971
Registered: December 2004

Senior Member

if you need the data to be on a different database you can achieve this using a materialized view.

Report message to a moderator

Previous Topic:	PL/SQL Script execution metics in Oracle
Next Topic:	oracle procedure compile syntax check

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:50:45 CDT 2024