OraFAQ Forum: Server Utilities » Dump Table from One Schema to Other schema

Home » RDBMS Server » Server Utilities » Dump Table from One Schema to Other schema (Oracle 10g)

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

Dump Table from One Schema to Other schema [message #445900]

Thu, 04 March 2010 10:19

mjkreddy1927
Messages: 20
Registered: February 2007

Junior Member

HI Friends, I need help i resolving my small issue,

i need to dump the table from A schema to B schema with diffrent table name.

Suppose i have TABLE A IN "A" SCHEMA i need to dump the table with DATA+sTRUCTURE in " B"SCHEMA WITH TABLE NAME AS B.

Report message to a moderator

Re: Dump Table from One Schema to Other schema [message #445901 is a reply to message #445900]

Thu, 04 March 2010 10:36

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

Senior Member
Account Moderator

Import it in schema B and then rename the tables.

Regards
Michel

Report message to a moderator

Re: Dump Table from One Schema to Other schema [message #445903 is a reply to message #445900]

Thu, 04 March 2010 10:56

ora_baby
Messages: 89
Registered: May 2008

Member

if you in shema B

create table table1 
as select * from A.table2

[Updated on: Thu, 04 March 2010 10:56]

Report message to a moderator

Re: Dump Table from One Schema to Other schema [message #445904 is a reply to message #445903]

Thu, 04 March 2010 10:59

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

ora_baby wrote on Thu, 04 March 2010 16:56

if you in shema B

create table table1 
as select * from A.table2

And then you'll have to recreate any triggers, indexes and constraints on that table.

Report message to a moderator

Previous Topic:	CONCAT fails in SQL*Loader
Next Topic:	Can i partially import dump?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 07:43:03 CST 2024