Install or upgrade Oracle APEX 5.0.3 for ORACLE DATABASE 12C on Linux
Step 1: Create tablespace create tablespace apex datafile '/u01/app/oracle/oradata/PTUD/datafile/apex.dbf' size 100M autoext...
How to select columns with null values
Connect with your schema and run the sql scripts SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; SELECT t.table_name, t.column_name...
How to connect PENTAHO with Oracle Database (12c/11g)
Step 1: Set JAVA environment for PENTAHO My Computer --> Properties( Click right mouse My Computer) --> Advanced system settings --...
Example Creating tablespace in Oracle Database.
Create undo tablespace: create undo tablespace undotbs2 datafile '/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf' size ...
Displaying Backup Information Oracle Database
[oracle@VTGDB-Server app]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 25 13:56:15 2016 Copyright (c) 1982, 2013,...
Clone a Pluggable Database (PDB) Manually
[oracle@VTGDB.BLOGSPOT.COM ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Feb 2 08:34:44 2016 Copyright (c) 1982, 20...
How to create a role and grant the role for user/schema in Oracle Database
create role "DEV" NOT IDENTIFIED; grant CREATE TRIGGER to "DEV"; grant CREATE SEQUENCE to "DEV"; grant...
SQL ORACLE select column name of a table
SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; SELECT column_name FROM USER_TAB_COLUMNS WHERE table_name = ' TABLE_NAME ' ...
Backup Full Database 12c Script
Task 1: Preparing to Use the Oracle Suggested Backup Strategy To use the Oracle suggested backup strategy, ensure that: The database is A...
How to drop or truncade all partitions Oracle Database
[oracle@PTUD-VM02-2 oradata]$ more drop_partition_table.sql SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; select 'ALTER TABLE...
Granting select privilege for owner' all tables to others
[oracle@PTUD-S07 ~]$ cat a.sql select 'GRANT SELECT ON OCDM_SYS.'||Table_Name||' TO OCDM_REPORT;' from All_Tables where owne...
Resize your Oracle datafiles down to the minimum without ORA-03297
Read it: http://blog.dbi-services.com/resize-your-oracle-datafiles-down-to-the-minimum-without-ora-03297/ set linesize 1000 pagesize 0 feed...
Find users belongs to tablespace
select distinct owner from dba_segments where tablespace_name='DATA201502'; OWNER ------------------------------ CC_OWNER CM_POS2 PA...
TABLESPACE USAGE
select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.largest, round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used from ...
How to dump file ( export and import) on pluggable database
1. Check listener [oracle@PTUD-SingleSignOn ~]$ lsnrctl status LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 09-SEP-2015 17:57:...
