Murat
Congratulations on moving the tables out of the SYSTEM tablespace. That
is how most of us become better DBAs -- by doing it wrong first. I've
learned those lessons myself. Now I read this list and learn from the
mistakes of others.
If the tables you are moving data into already contain data, you need to
decide how to make sure you don't end up with duplicate data. If each table
has a primary key, this will prevent duplicate data, but then your import
will fail. If the data overlaps and you want the data from the other
instance to be loaded, you can first delete the data that overlaps and then
import the data.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, December 02, 2002 9:30 AM
To: Multiple recipients of list ORACLE-L
answeres inserted.
DENNIS WILLIAMS
<DWILLIAMS@LIFETO To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
UCH.COM> cc:
Sent by: Subject: RE: move some
records of some tables
[EMAIL PROTECTED]
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.
[EMAIL PROTECTED]
-----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
--------------------------------------
Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel
haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji
geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri
Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir
hukuksal sorumlulugu kabul etmez.
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: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MURAT BALKAS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
