oracle 18 c xe import from dmp
With sqldeveloper could be easy created schema with specificaly privileges
to this desired users
then in terminal need run command imp
export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export ORACLE_SID=XEPDB2
./imp SCHEMANAME/SCHEMAPASS@localhost:1521/xepdb1 file=/opt/Compiere.dmp FULL=Y
With sqldeveloper could be easy created schema with specificaly privileges
to this desired users
then in terminal need run command imp
export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export ORACLE_SID=XEPDB2
./imp SCHEMANAME/SCHEMAPASS@localhost:1521/xepdb1 file=/opt/Compiere.dmp FULL=Y
Нема коментара:
Постави коментар