Oracle database commands

oracle.md

Create user

$ ORACLE_SID=XE sqlplus /nolog
SQL> connect / as sysdba;
SQL> CREATE USER username IDENTIFIED BY apassword;
SQL> GRANT CONNECT TO username;
SQL> GRANT CREATE SESSION TO username;
SQL> GRANT CREATE TABLE TO username;
SQL> GRANT UNLIMITED TABLESPACE TO username;

Import DB with Oracle Datapump

$ ORACLE_SID=XE sqlplus /nolog
SQL> connect / as sysdba;
SQL> CREATE USER TORPEMP IDENTIFIED BY TORPEMP;
SQL> GRANT CONNECT TO TORPEMP;
SQL> GRANT CREATE SESSION TO TORPEMP;
SQL> GRANT CREATE TABLE TO TORPEMP;
SQL> GRANT UNLIMITED TABLESPACE TO TORPEMP;
SQL> CREATE OR REPLACE DIRECTORY test_dir AS '/home/oracle/db';
SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO TORPEMP;
SQL> create tablespace TSTORPEMP_DATA datafile '/home/oracle/db/TSTORPEMP_DATA.dbf' size 50m ;

$ cp *.dmp *.log /home/oracle/db
$ ORACLE_SID=XE impdp TORPEMP/TORPEMP directory=TEST_DIR full=Y dumpfile=exp_torpemp_03-11-2014.dmp logfile=exp_torpemp_03-11-2014.log