|
|
|
Re: No , If you are importing only data from Source To Destiny Table [message #116332 is a reply to message #116296] |
Tue, 19 April 2005 08:45 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Britul wrote:
>>Answer : Yes
>>If u are importing the whole D'base or user or table then your >>previous data will be lost for that d'base, user & table >>respectively
No. Wrong.
Import will append.
Please look into the session.
with Ignore=y exp will not complain about the pre-existing object.
If ignore=y is NOT specified, you import will fail stating the object already exists.
First export will export 56 rows.
Import will import those 56 rows.
Total count will be 112 rows.
bash-2.03$ exp mag/mag tables=(mytable) file=mag.dmp
Export: Release 9.2.0.4.0 - Production on Tue Apr 19 08:35:06 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table MYTABLE 56 rows exported
Export terminated successfully without warnings.
bash-2.03$ imp mag/mag file=mag.dmp full=y ignore=y
Import: Release 9.2.0.4.0 - Production on Tue Apr 19 08:35:35 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing MAG's objects into MAG
. . importing table "MYTABLE" 56 rows imported
Import terminated successfully without warnings.
bash-2.03$ count mutation mag.mytable;
Table:mag.mytable
COUNT(*)
----------
112
|
|
|