| import [message #73904] |
Mon, 02 August 2004 04:00  |
p anil
Messages: 4
Registered: August 2004
|
Junior Member |
|
|
i have a user plntfin
i have some data in the database relating to plntfin
after a week i got another exp file from my
plantation department so now i have to append
the data to previous one
how can i append data to previous data in imp?
what option i have to specify
|
|
|
|
| Re: import [message #73905 is a reply to message #73904] |
Mon, 02 August 2004 04:22  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Nothing.
By default import appends the data.
use ignore =y during import, which will just ignore the presence of the object.
if there is a primary key or any other constraint involved, a violation is reported and record will not be inserted.
--
-- lets check records in emp table
--
bash-2.03$ count mutation mag.emp
Table:mag.emp
COUNT(*)
----------
14
--
-- do an export
--
bash-2.03$ exp mag/mag@mutation owner=mag statistics=none
Export: Release 9.2.0.4.0 - Production on Mon Aug 2 08:19:44 2004
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 users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MAG
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MAG
About to export MAG's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export MAG's tables via Conventional Path ...
. . exporting table BONUS 0 rows exported
. . exporting table DEPT 6 rows exported
. . exporting table EMP 14 rows exported
. . exporting table ID 2 rows exported
. . exporting table MEMBER 3 rows exported
. . exporting table MYOBJ 4 rows exported
. . exporting table PARAMETER 0 rows exported
. . exporting table SALGRADE 5 rows exported
. . exporting table T_LT 2 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
--
-- do an import with ignore=y
--
bash-2.03$ imp mag/mag@mutation fromuser=mag touser=mag tables=(emp) ignore=y
Import: Release 9.2.0.4.0 - Production on Mon Aug 2 08:19:53 2004
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 table "EMP" 14 rows imported
Import terminated successfully without warnings.
--
-- check again
--
bash-2.03$ count mutation mag.emp
Table:mag.emp
COUNT(*)
----------
28
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
