OraFAQ Forum: Server Administration » Oracle Database Copying

Home » RDBMS Server » Server Administration » Oracle Database Copying

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

Oracle Database Copying [message #56251]

Fri, 14 March 2003 02:33

C.Esakki Arumugam
Messages: 2
Registered: March 2003

Junior Member

How can I copy one table from One database from One database to Other oracle server database... Both are having same database name in the windows 2000 server system (Seperately installed).

Report message to a moderator

Oracle Database Table Copying [message #56252 is a reply to message #56251]

Fri, 14 March 2003 02:38

C.Esakki Arumugam
Messages: 2
Registered: March 2003

Junior Member

How Can I copy a table from one oracle server database to other oracle database server in which two server (windows 2000 server) installed ? Is it any trigger used for that ??? Please send the reply immediately... Awaiting your favourable reply

Report message to a moderator

Re: Oracle Database Table Copying [message #56253 is a reply to message #56251]

Fri, 14 March 2003 05:35

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can 
1. use export / import
2. create a dblink between the two databases
   use the following sytanx

   create table newtable as select * from oldtable@database1

  NOTE:
  any constraints in the source table,
  wont be created here.. you need to that manually.

Report message to a moderator

Previous Topic:	Partioning table
Next Topic:	Urgent :ORA-03113 End of Communication on Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 23:48:51 CST 2024