Category Technologies

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 […]

GIT USEFUL PRACTICES

The terminal prompt below is currently in a directory decided to name “octobox”. To initialize a Git repository here, type the following command: –git init our “octobox” directory now has an empty repository in /.git/. The repository is a hidden directory where Git operates. Directory: A folder used for storing multiple files. Repository: A directory where […]

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 […]

Hibernate criteria IN clause: List size more than 1000 values

If list size is more than 1000 values in IN CLAUSE then it throws below oracle error: Error : ORA-01795: maximum number of expressions in a list is 1000 Oracle does not allow more than 1000 parameter values in a IN clause.  Avoiding Error By Oracle : You could use one of the workarounds i.e. By […]