Home » RDBMS Server » Server Utilities » Dump Table from One Schema to Other schema (Oracle 10g)
icon12.gif  Dump Table from One Schema to Other schema [message #445900] Thu, 04 March 2010 10:19 Go to next message
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.

Re: Dump Table from One Schema to Other schema [message #445901 is a reply to message #445900] Thu, 04 March 2010 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Import it in schema B and then rename the tables.

Regards
Michel
Re: Dump Table from One Schema to Other schema [message #445903 is a reply to message #445900] Thu, 04 March 2010 10:56 Go to previous messageGo to next message
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 Go to previous message
cookiemonster
Messages: 12320
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.
Previous Topic: CONCAT fails in SQL*Loader
Next Topic: Can i partially import dump?
Goto Forum:
  


Current Time: Mon Sep 26 09:24:56 CDT 2016

Total time taken to generate the page: 0.20535 seconds