Home » RDBMS Server » Server Utilities » How to copy table from user to another user in another server
How to copy table from user to another user in another server [message #71199] Mon, 23 September 2002 22:38 Go to next message
Aor
Messages: 2
Registered: September 2002
Junior Member
hello!
I want to make a copy of all tables and views, index ,relation including date in that table from one user'schema to another user'schema at another server. from 8i to 9i.
how it is possible

Report message to a moderator

Re: How to copy table from user to another user in another server [message #71203 is a reply to message #71199] Tue, 24 September 2002 07:20 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
EXPORT from source and IMPORT in the target

Report message to a moderator

Previous Topic: Another ora-12560 error. Needs to work by Fri.
Next Topic: Exporting a data which is stored in another system
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 02:49:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.