Limiting User Privileges when you install sample reports

[oracle@PTUD-S07 ~]$ more a.sql 
SET LINESIZE 32000;
SET PAGESIZE 40000;
SET LONG 50000;

select 'CREATE OR REPLACE EDITIONABLE SYNONYM OCDM_REPORT.'||Table_Name||' for OCDM_SYS.'||Table_Name||';' from All_Tables where owner='OCDM_SYS';

[oracle@PTUD-S07 ~]$ sqlplus / as sysdba @a.sql >> b.sql &

[4] 141981

[oracle@PTUD-S07 ~]$ cat b.sql | grep 'CREATE OR REPLACE EDITIONABLE SYNONYM' >> c.sql

[4]+  Stopped                 sqlplus / as sysdba @a.sql >> b.sql

[oracle@PTUD-S07 ~]$ sqlplus / as sysdba @c.sql

Tweet