Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
1: key in sqlplus from command window, input user name and pw, pw is created when install oracle db, user name is system default user name
C:\Users\Administrator>sqlplus
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Oct 13 22:21:32 2022
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Enter user-name: SYSTEM
Enter password:
Last Successful login time: Thu Oct 13 2022 22:12:27 -07:00
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
2: run below command
SQL> ALTER SESSION SET"_ORACLE_SCRIPT"=TRUE;
Session altered.
3: create new user ''comfort" and password "password"
SQL> CREATE USER comfort IDENTIFIED BY password;
User created.
4: Grant dba to this new user,
SQL> grant dba to comfort;
Grant succeeded.
Try import db here(do exp first from original db server with below command: exp SYSTEM/[email protected]:1521/XE owner=SYSTEM file=C:\Temp\test.dmp)
Take note, imp and exp command is not under sqlplus mode, just normal command window key in exp and imp command
imp comfort/password@XE file=C:\CastlesTMSDb\XE_220407.dmp log=C:\CastlesTM
below is part of import success log for reference only:
----------------------------------------------------------------------------------------
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "COMFORT"."MVIEW_EXCEPTIONS" "
" "
" ("RUNID","OWNER","TABLE_NAME","DIMENSION_NAME","RELATION"
"SHIP","BAD_ROWID") AS "
"select"
" t1.runid# as runid,"
" owner,"
" table_name,"
" dimension_name,"
" relationship,"
" bad_rowid"
"from SYSTEM.MVIEW$_ADV_EXCEPTIONS t1, SYSTEM.MVIEW$_ADV_LOG t2, ALL_USERS u"
"where"
" t1.runid# = t2.runid# and"
" u.username = t2.uname and"
" u.user_id = userenv('SCHEMAID')"
Import terminated successfully with warnings.
C:\Users\Administrator>
----------------------------------------------------------------------------------------
标签:name,windows,DB,add,command,user,SQL,password,runid From: https://www.cnblogs.com/renren0113/p/16791339.html