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.
--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
Subscribe to:
Post Comments (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...
No comments:
Post a Comment