четвртак, 15. новембар 2018.

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

Нема коментара:

Постави коментар