Monday, January 8, 2018

Import dmp file in oracle 12c database

SQL> conn starerp/starerp@orcldb
Connected.
SQL>
SQL>
SQL>
SQL>
SQL> host imp

Import: Release 12.2.0.1.0 - Production on Mon Jan 8 14:51:57 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Username: starerp
Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Import data only (yes/no): no >

Import file: EXPDAT.DMP > E:\12c_DMP\STARERP-08-01-2018.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V12.02.00 via conventional path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
IMP-00403:

Warning: This import generated a separate SQL file "import_sys" which contains DDL that failed due to a privilege issue.

List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no > y

IMP-00001: respond with either yes, no, RETURN or '.' to quit
Import entire export file (yes/no): no >
Username: starerp

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:

. importing STARERP's objects into STARERP
. importing STARERP's objects into STARERP
. . importing table             "STRERP_USER_INFO"          2 rows imported
. . importing table             "STRERP_MENU_INFO"         25 rows imported
. . importing table          "STRERP_REPSERVER12C"          1 rows imported
. . importing table           "STRERP_USER_MODULE"         37 rows imported
IMP-00041: Warning: object created with compilation warnings
 "CREATE TRIGGER "STARERP"."ENCRYPTED_DATA_BIUR_TRG" "
 "BEFORE INSERT OR UPDATE of user_password ON STRERP_USER_INFO"
 "FOR EACH ROW"
 "DECLARE"
 "BEGIN"
 "  :new.user_password := toolkit.encrypt(:new.user_password);"
 "END;"
About to enable constraints...
Import terminated successfully with warnings.

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...