Display the contents of the recycle bin show recyclebin Empty the recycle bin purge recyclebin Drop an object with out putting it in the recycle bin drop <object_type> <object_name> purge;
How Big Is The Database
col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ‘ GB’ “Database Size” , round(sum(used.bytes) / 1024 / 1024 / 1024 ) – round(free.p / 1024 / 1024 / 1024) || ‘ GB’ “Used space” , round(free.p / 1024 [...]
Displays Information About Database Services.
Description : Displays information about database services. Requirements : Access to the DBA views. Call Syntax : @services ———————————————————————————— SET LINESIZE 200 COLUMN name FORMAT A30 COLUMN network_name FORMAT A50 SELECT name, network_name FROM dba_services ORDER BY name;
Create The Demo User SCOTT/TIGER
To create the SCOTT/TIGER login for the demo, run the below script : $ORACLE_HOME/rdbms/admin/utlsampl.sql as system/manager. For example: % cd $ORACLE_HOME/rdbms/admin % svrmgrl SVRMGR>CONNECT system/manager SVRMGR>@utlsampl.sql
Enable Flashback For A RAC Database On ASM
In RAC we only need to enable flashback on one of the instances, the other instances will then startup in flashback mode. In a RAC Database, flashback recovery area must be stored in clustered file system or in ASM. Prerequisites * Database must be in Archive log mode * Must have flash recovery area configured Follow [...]
Common Errors in Oracle
ORA-00001: Unique constraint violated Cause: When to try to Update or Insert duplicate key. Remedy: Either don’t insert the value or remove the unique restriction. Following statement used to identify the columns of the table this constraint is based upon:Select table_name, column_name from all_cons_columns where owner=’<Here OWNER>’ and constraint_name=’<Here CONSTRAINT_NAME>’ order by position; ORA-00020: Maximum [...]