Home » RDBMS Server » Server Utilities » import
import [message #73904] Mon, 02 August 2004 04:00 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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

Previous Topic: sqlj remotely
Next Topic: exp error(about 15g data)
Goto Forum:
  


Current Time: Wed Jul 03 10:48:09 CDT 2024