Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: move some records of some tables
answeres inserted.
DENNIS WILLIAMS <DWILLIAMS_at_LIFETO To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> UCH.COM> cc: Sent by: Subject: RE: move some records of some tables root_at_fatcity.com 12/02/2002 03:44 PM Please respond to ORACLE-L
Murat - The best method depends on several circumstances such as how much data is involved. The simplest method if you have two Oracle instances is export/import.
Is the username the same on both instances? Yes.
Are there differences between the instances such as NLS character sets? No, they're the same.
Are both instances the same Oracle version? Yes.
Are you moving all the tables for the user? No.
All the rows in each table?
No.
Do those tables already exist on the other instance? Yes.
If yes, do the tables already contain data? Yes.
And... Another difference is : Original tables are on the SYSTEM tablesapce. This was made by mistake. Tables I'll import to are on another tablespace.
If you are not familiar with the Oracle export/import utilities, a good
start is to look at this link.
http://www.orafaq.net/faqiexp.htm
Thanks, I'll look at it.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, December 02, 2002 5:44 AM
To: Multiple recipients of list ORACLE-L
Hi,
what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this.
Thanks,
Murat
This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MURAT BALKAS
INET: murat.balkas_at_o2.net.tr
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MURAT BALKAS
INET: murat.balkas_at_o2.net.tr
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 02 2002 - 09:29:36 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |