Category Oracle

ORACLE TIPS

USER/SCHEMA: – Create new user CREATE USER USRPPTEST1 IDENTIFIED BY VALUES ‘USRPPTEST1’ DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT DBA TO USRPPTEST1; GRANT CONNECT TO USRPPTEST1; GRANT RESOURCE TO USRPPTEST1; ALTER USER USRPPTEST1 DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO USRPPTEST1; – Add privileges to new user GRANT CREATE SESSION TO […]

Oracle: Steps to Install Dumps on Local Database

All Users have the oracleXE in our local machine, sometime we need to import the dump for Projects in local machine. We need to follow these steps to import the dump in our local machine : Step 1: Connect with the system user from cmd prompt. sqlplus user/password@XE as sysdba; Step 2 (optional): For some¬†Project¬†we […]