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 owner='OCDM_SYS'; [oracle@PTUD-S07 ~]$ sqlplus / as sysdba @a.sql >> b.sql & [3] 28402 [oracle@PTUD-S07 ~]$ cat b.sql | grep 'GRANT SELECT ON' >> c.sql [oracle@PTUD-S07 ~]$ sqlplus / as sysdba @c.sql ...

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 feedback off trimspool on with  hwm as (   -- get highest block id from each datafiles ( from x$ktfbue as we don't need all joins from dba_extents )   select /*+ materialize */ ktfbuesegtsn ts#,ktfbuefno relative_fno,max(ktfbuebno+ktfbueblks-1)...

How to vncviewer with your size

$ vncserver -geometry 1920x108...

Find users belongs to tablespace

select distinct owner from dba_segments where tablespace_name='DATA201502'; OWNER ------------------------------ CC_OWNER CM_POS2 PAYMENT VT_IT_TC_KM PRIVILEGE_OWNER MEDIATION BCCS_GW QLKD_BD 8 rows selected. ...

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 ( select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files group by TABLESPACE_NAME ) a, ( select TABLESPACE_NAME, sum(BYTES) BYTES , max(BYTES) largest from dba_free_space group by TABLESPACE_NAME ...

How to see files'size and sort them on one folder Linux

[oracle@PTUD-VM02-2 datafile]$ ls --reverse --sort=size  -sh ...

How to backup, restore BI Publisher 11G

Backup Backup Fusion Middleware Directory For Example: [oracle@App1 fmw]$ cd /u01/app [oracle@App1 app]$ ls backup  fmw  obiee_home  oracle  p6 [oracle@App1 app]$ cp -R fmw/ fmw_bak Backup Database: Contact DBA to do that. Backup 2 schemas (For Example: dev_biplatform, dev_mps) which created by RCU. Restore Restore Fusion...

How to switch from ‘Oracle Fusion Middleware’ to ‘Bi Publisher Security’

Prerequisite: Backup Your Fusion Middleware directory home. [rms_bi_vtg@BI-VTG-02 ~]$ cp -R fmw/ fmw_bak Backup Catalog Folder. Step by Step: Step 1: Access Oracle BI Publisher Enterprise via Web Browser http://YOUR_IP_SERVER:9704/xmlpserver ...

Starting, Stopping Services BI Publisher 11g

Starting, Stopping Services Starting Services: Step 1: Starting Admin Server: [oracle@App1 fmw]$ cd user_projects/domains/bifoundation_domain/ [oracle@App1 bifoundation_domain]$ pwd /u01/app/fmw/user_projects/domains/bifoundation_domain [oracle@App1 bifoundation_domain]$ ./startWebLogic.sh … Enter username to boot WebLogic server:weblogic Enter password...

BI Publisher Installation

Read more: https://drive.google.com/open?id=0B7a3DEnQ0-uzblN3Ylo1N3g1...

P6 EPPM R15.1 INSTALLATION AND CONFIGURATION CHECKLIST

Outline: Table of Contents  TOC \o "1-3" \h \z \u Install and configure Single Sign-On Checklist PAGEREF _Toc434224586 \h 3 08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003400330034003200320034003500380036000000 Pre-Installation Checklist:...