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.
Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
Subscribe to:
Post Comments (Atom)
How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10
#########################Install Oracle APEX 24.1################################ ----------------------------------------------------...
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment