[tibero@T1:/tibero/tibero7/client/bin]$ which tbsql
./tbsql
[tibero@T1:/tibero/tibero7/client/bin]$
[tibero@T1:/tibero/tibero7/client/bin]$
[tibero@T1:/tibero/tibero7/client/bin]$
[tibero@T1:/tibero/tibero7/client/bin]$
[tibero@T1:/tibero/tibero7/client/bin]$ cd /tibero
[tibero@T1:/tibero]$ vi sample.sql
[tibero@T1:/tibero]$ tbsql
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
SQL> @/tibero/sample.sql
Connected to Tibero.
User 'SCOTT' created.
Granted.
Connected to Tibero.
TBR-7071: Schema object 'SCOTT.EMP' was not found or is invalid.
TBR-7071: Schema object 'SCOTT.DEPT' was not found or is invalid.
TBR-7071: Schema object 'SCOTT.BONUS' was not found or is invalid.
TBR-7071: Schema object 'SCOTT.SALGRADE' was not found or is invalid.
TBR-7071: Schema object 'SCOTT.DUMMY' was not found or is invalid.
Table 'EMP' created.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
Table 'DEPT' created.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
Table 'BONUS' created.
Table 'SALGRADE' created.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
1 row inserted.
Table 'DUMMY' created.
1 row inserted.
Commit completed.
SQL> q
Disconnected.
[tibero@T1:/tibero]$ cat sample.sql
-- SYS USER 로 접속하여 실행함.
CONNECT SYS/TIBERO
-- 1. DBA권한으로 접속하여 SCOTT USER를 생성 한다.
CREATE USER scott IDENTIFIED BY tiger
DEFAULT TABLESPACE usr
TEMPORARY TABLESPACE temp;
-- 2. 권한 부여
GRANT connect, resource TO scott;
-- 3. SCOTT USER로 접속해서 스크립트를 실행.
CONN scott/tiger
-- 4. SCOTT 스키마에 5개 테이블 생성과 데이터 입력.
DROP TABLE EMP;
DROP TABLE DEPT;
DROP TABLE BONUS;
DROP TABLE SALGRADE;
DROP TABLE DUMMY;
CREATE TABLE EMP
(EMPNO NUMBER(4) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
DEPTNO NUMBER(2));
INSERT INTO EMP VALUES
(7369, 'SMITH', 'CLERK', 7902,
sysdate, 800, NULL, 20);
INSERT INTO EMP VALUES
(7499, 'ALLEN', 'SALESMAN', 7698,
sysdate, 1600, 300, 30);
INSERT INTO EMP VALUES
(7521, 'WARD', 'SALESMAN', 7698,
sysdate, 1250, 500, 30);
INSERT INTO EMP VALUES
(7566, 'JONES', 'MANAGER', 7839,
sysdate, 2975, NULL, 20);
INSERT INTO EMP VALUES
(7654, 'MARTIN', 'SALESMAN', 7698,
sysdate, 1250, 1400, 30);
INSERT INTO EMP VALUES
(7698, 'BLAKE', 'MANAGER', 7839,
sysdate, 2850, NULL, 30);
INSERT INTO EMP VALUES
(7782, 'CLARK', 'MANAGER', 7839,
sysdate, 2450, NULL, 10);
INSERT INTO EMP VALUES
(7788, 'SCOTT', 'ANALYST', 7566,
sysdate, 3000, NULL, 20);
INSERT INTO EMP VALUES
(7839, 'KING', 'PRESIDENT', NULL,
sysdate, 5000, NULL, 10);
INSERT INTO EMP VALUES
(7844, 'TURNER', 'SALESMAN', 7698,
sysdate, 1500, 0, 30);
INSERT INTO EMP VALUES
(7876, 'ADAMS', 'CLERK', 7788,
sysdate, 1100, NULL, 20);
INSERT INTO EMP VALUES
(7900, 'JAMES', 'CLERK', 7698,
sysdate, 950, NULL, 30);
INSERT INTO EMP VALUES
(7902, 'FORD', 'ANALYST', 7566,
sysdate, 3000, NULL, 20);
INSERT INTO EMP VALUES
(7934, 'MILLER', 'CLERK', 7782,
sysdate, 1300, NULL, 10);
CREATE TABLE DEPT
(DEPTNO NUMBER(2),
DNAME VARCHAR2(14),
LOC VARCHAR2(13) );
INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO');
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');
CREATE TABLE BONUS
(ENAME VARCHAR2(10),
JOB VARCHAR2(9),
SAL NUMBER,
COMM NUMBER);
CREATE TABLE SALGRADE
(GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER);
INSERT INTO SALGRADE VALUES (1, 700, 1200);
INSERT INTO SALGRADE VALUES (2, 1201, 1400);
INSERT INTO SALGRADE VALUES (3, 1401, 2000);
INSERT INTO SALGRADE VALUES (4, 2001, 3000);
INSERT INTO SALGRADE VALUES (5, 3001, 9999);
CREATE TABLE DUMMY
(DUMMY NUMBER);
INSERT INTO DUMMY VALUES (0);
COMMIT;
[tibero@T1:/tibero]$ tbsql
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
SQL> select * from database;
TBS-70004: Not connected to the server.
SQL> LS USER
TBS-70004: Not connected to the server.
SQL> CONNECT TIBERO/TMAX
Connected to Tibero.
SQL> CREATE TABLE TIBERO.DEPT AS SELECT * FROM SCOTT.DEPT;
Table 'TIBERO.DEPT' created.
SQL> LS USER
USERNAME
--------------------------------------------------------------------------------
TIBERO
SQL> TRUNCATE TABLE SCOTT.DEPT;
Table 'SCOTT.DEPT' truncated.
SQL> SELECT * FROM SCOTT.DEPT;
0 row selected.
SQL> LS TABLE
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
DEPT TABLE
PRODUCT TABLE
SQL> CONN SCOTT/TIGER
Connected to Tibero.
SQL> LS TABLE
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
BONUS TABLE
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE
-> tibero studio 에서 tbExport 후 import 하기 table이 존재하므로 ignore 하기
-> 데이터가 제대로 들어 갔는지 확인하기 (티베로 스튜디오 내부에서)
SQL> -- 테이블 자체를 없애고 import 하기
SQL> DROP TABLE DEPT;
Table 'DEPT' dropped.
SQL> LS TABLE
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
BONUS TABLE
DUMMY TABLE
EMP TABLE
SALGRADE
SQL> LS TABLE
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
BONUS TABLE
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE
SQL> SELECT * FROM DEPT;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
4 rows selected.
SQL> TRUNCATE TABLE DEPT;
Table 'DEPT' truncated.
SQL> TRUNCATE TABLE EMP;
Table 'EMP' truncated.
SQL> SELECT * FROM DEPT;
0 row selected.
SQL> LS TABLE;
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
BONUS TABLE
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE
SQL> LS USER
USERNAME
--------------------------------------------------------------------------------
SCOTT
SQL> LS TABLE;
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
BONUS TABLE
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE
SQL>
SQL>
SQL> -- tbImport 후 확인 하기 티베로 스튜디오 사용법 확인! 테이블 두개를 삽입할 경우
SQL> -- 갯수가 0에서 증가함을 알 수 있다.
SQL> SELECT COUNT(*) FROM DEPT;
COUNT(*)
----------
0 -> 4
1 row selected.
SQL> SELECT COUNT(*) FROM EMP;
COUNT(*)
----------
0 -> 14
1 row selected.
[tibero@T1:/tibero]$ which tbexport
/tibero/tibero7/client/bin/tbexport
[tibero@T1:/tibero]$ which tbimport
/tibero/tibero7/client/bin/tbimport
[tibero@T1:/tibero]$ mkdir expimp
[tibero@T1:/tibero]$ cd expimp/
[tibero@T1:/tibero/expimp]$ tbexport
tbexport 7.0
Copyright 2020 TmaxTibero Co., Ltd. All Rights Reserved.
Usage : tbexport [options] [parameter=value parameter=value ...]
Options:
-h|--help Display the more detailed information.
-v|--version Display the version information.
-p|--patch Display the binary's patch information.
Parameters:
CFGFILE Config file name
COMPRESS Compress Mode: Y/N, default: N
CONSTRAINT Export Constraint: Y/N, default: Y
CONSISTENT Consistent Mode: Y/N, default: N
ENCRYPTION Encryption Mode: all/data_only/metadata_only/encrypted_columns_only/none, default: none
ENCRYPTION_PASSWORD Encryption Password to encrypt dump file
EXCLUDE Limit the export to specific objects
FILE Export dump file name, default: default.dat
FULL Full Mode: Y/N, default: N
GEOM_ASBYTES Export the geometry columns as bytes, default: N
GRANT Export Grant: Y/N, default: Y
INDEX Export Index: Y/N, default: Y
INLINE_CONSTRAINT Use the Inline Constraint: Y/N, default: N (this option is only supported for the not null)
IP IP address, default: localhost
LOG Export script log file name
LOGDIR Export log directory
NO_PACK_DIR Export unpacked dump files to specified directory.
If this option is specified, FILE parameter will be ignored.
OVERWRITE Overwrite datafile if same file name exists: Y/N, default: N
PASSWORD User password
PORT PORT number, default: 8629
QUERY Where predicate: (Optional) to filter data to be exported
(must be used with TABLE parameter)
REMAP_TABLE Remaps the objects from the source table to the target table.
REMAP_TABLESPACE Remaps the objects from the source tablespace to the target tablespace.
ROWS Export Table Rows: Y/N, default: Y
SAVE_CREDENTIAL Save your username and password to specified file
SCRIPT LOG THE DDL SCRIPT: Y/N, default: N
SID Database name
TABLE Table Mode: table name list.
Append :<Partition Name> to select a single partition (Optional)
TEMP_DIR Directory for the temporary raw dump files.
THREAD_CNT Thread Count, default: 4
USER User Mode: user name list
USERNAME Database user name
NOVALIDATE NOVALIDATE: Y/N , default: N
INDEX_PARALLEL_DEGREE Export Indexes with parallel indexing value default:NOPARALLEL
[tibero@T1:/tibero/expimp]$ tbexport IP=localhost PORT=8629 SID=tibero USERNAME=sys PASSWORD=tibero full=y script=y
tbexport 7.0
Copyright 2020 TmaxTibero Co., Ltd. All Rights Reserved.
the entire database: Tue Apr 11 15:32:03 KST 2023
Export national character set: UTF-16
exporting tablespaces
exporting roles
exporting public synonyms
exporting schema:"SCOTT"
exporting tables
[2] SCOTT.DUMMY 1 rows exported.
[1] SCOTT.DEPT 4 rows exported.
[0] SCOTT.BONUS no rows exported.
[3] SCOTT.EMP 14 rows exported.
[2] SCOTT.SALGRADE 5 rows exported.
exporting constraints
exporting schema:"TIBERO"
exporting tables
[0] TIBERO.DEPT 4 rows exported.
[1] TIBERO.PRODUCT 1000001 rows exported.
exporting indexes
exporting schema:"TIBERO1"
Packing the file...
Export completed successfully : Tue Apr 11 15:32:09 KST 2023
[tibero@T1:/tibero/expimp]$ ls -al
total 8368
drwxr-xr-x 2 tibero dba 79 Apr 11 15:32 .
drwxrwxr-x. 5 tibero dba 248 Apr 11 15:25 ..
-rw-r--r-- 1 tibero dba 8294400 Apr 11 15:32 default.dat
-rw-r--r-- 1 tibero dba 98925 Apr 11 15:32 ExpImp_23_04_11_153203.log
-rw-r--r-- 1 tibero dba 169239 Apr 11 15:32 tbExport.log
[tibero@T1:/tibero/expimp]$
[tibero@T1:/tibero/expimp]$
[tibero@T1:/tibero/expimp]$ cat ExpImp_23_04_11_153203.log
-- Parameters: IP=localhost PORT=8629 SID=tibero USERNAME=sys PASSWORD=xxxx full=y script=y
-- the entire database: Tue Apr 11 15:32:03 KST 2023
-- Export national character set: UTF-16
-- exporting tablespaces
CREATE TABLESPACE "SYSTEM" DATAFILE
'/tibero/tbdata/tibero/system001.dtf' SIZE 171966464 AUTOEXTEND ON NEXT 67108864 MAXSIZE 3221225472
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
/
CREATE TABLESPACE "USR" DATAFILE
'/tibero/tbdata/tibero/usr001.dtf' SIZE 52428800 AUTOEXTEND ON NEXT 67108864 MAXSIZE 3221225472
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
/
CREATE TABLESPACE "SYSSUB" DATAFILE
'/tibero/tbdata/tibero/syssub001.dtf' SIZE 52428800 AUTOEXTEND ON NEXT 67108864 MAXSIZE 3221225472
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
/
CREATE TABLESPACE "MY_SPACE" DATAFILE
'/tibero/tibero7/tbdata/my_file001.dtf' SIZE 52428800 AUTOEXTEND ON NEXT 10485760 MAXSIZE 3221225472
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 262144
/
-- exporting roles
CREATE ROLE "PUBLIC"
/
CREATE ROLE "DBA"
/
CREATE ROLE "CONNECT"
/
CREATE ROLE "RESOURCE"
/
CREATE ROLE "SELECT_CATALOG_ROLE"
/
CREATE ROLE "HS_ADMIN_ROLE"
/
CREATE USER "SCOTT" IDENTIFIED BY ENCRYPTED 'BgrvPP+abOSC51uzRVfIdaYn+cmNBRUkVd751TyLWF8='
DEFAULT TABLESPACE "USR"
/
CREATE USER "TIBERO" IDENTIFIED BY ENCRYPTED 'd/+EnwJb70RwWgHUK2w+8+Ao/gfDr46BjyybXZLBpKU='
DEFAULT TABLESPACE "USR"
/
CREATE USER "TIBERO1" IDENTIFIED BY ENCRYPTED 'd/+EnwJb70RwWgHUK2w+8+Ao/gfDr46BjyybXZLBpKU='
DEFAULT TABLESPACE "USR"
/
GRANT CREATE SESSION TO CONNECT
/
GRANT ADMINISTER DATABASE TRIGGER TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY INDEX TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY INDEXTYPE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY MATERIALIZED VIEW TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY OPERATOR TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY PROCEDURE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY ROLE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY SEQUENCE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY SQL TRANSLATION PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY TRIGGER TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ANY TYPE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER DATABASE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER RMGR TO DBA
WITH ADMIN OPTION
/
GRANT ALTER ROLLBACK SEGMENT TO DBA
WITH ADMIN OPTION
/
GRANT ALTER SESSION TO DBA
WITH ADMIN OPTION
/
GRANT ALTER SYSTEM TO DBA
WITH ADMIN OPTION
/
GRANT ALTER TABLESPACE TO DBA
WITH ADMIN OPTION
/
GRANT ALTER USER TO DBA
WITH ADMIN OPTION
/
GRANT ANALYZE ANY TO DBA
WITH ADMIN OPTION
/
GRANT AUDIT ANY TO DBA
WITH ADMIN OPTION
/
GRANT AUDIT SYSTEM TO DBA
WITH ADMIN OPTION
/
GRANT COMMENT ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY CONTEXT TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY DATABASE LINK TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY DIRECTORY TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY INDEX TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY INDEXTYPE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY LIBRARY TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY MATERIALIZED VIEW TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY OPERATOR TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY PROCEDURE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY SEQUENCE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY SQL TRANSLATION PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY SYNONYM TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY TRIGGER TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY TYPE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ANY VIEW TO DBA
WITH ADMIN OPTION
/
GRANT CREATE BTIP TO DBA
WITH ADMIN OPTION
/
GRANT CREATE DATABASE LINK TO DBA
WITH ADMIN OPTION
/
GRANT CREATE INDEXTYPE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE LIBRARY TO DBA
WITH ADMIN OPTION
/
GRANT CREATE MATERIALIZED VIEW TO DBA
WITH ADMIN OPTION
/
GRANT CREATE OPERATOR TO DBA
WITH ADMIN OPTION
/
GRANT CREATE PROCEDURE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE PUBLIC DATABASE LINK TO DBA
WITH ADMIN OPTION
/
GRANT CREATE PUBLIC SYNONYM TO DBA
WITH ADMIN OPTION
/
GRANT CREATE ROLE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE SEQUENCE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE SESSION TO DBA
WITH ADMIN OPTION
/
GRANT CREATE SQL TRANSLATION PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE SYNONYM TO DBA
WITH ADMIN OPTION
/
GRANT CREATE TABLE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE TABLESPACE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE TIP TO DBA
WITH ADMIN OPTION
/
GRANT CREATE TRIGGER TO DBA
WITH ADMIN OPTION
/
GRANT CREATE TYPE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE USER TO DBA
WITH ADMIN OPTION
/
GRANT CREATE VIEW TO DBA
WITH ADMIN OPTION
/
GRANT DELETE ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT DEQUEUE ANY QUEUE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY CONTEXT TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY DATABASE LINK TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY DIRECTORY TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY INDEX TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY INDEXTYPE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY LIBRARY TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY MATERIALIZED VIEW TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY OPERATOR TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY PROCEDURE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY ROLE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY SEQUENCE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY SQL TRANSLATION PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY SYNONYM TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY TRIGGER TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY TYPE TO DBA
WITH ADMIN OPTION
/
GRANT DROP ANY VIEW TO DBA
WITH ADMIN OPTION
/
GRANT DROP PROFILE TO DBA
WITH ADMIN OPTION
/
GRANT DROP PUBLIC DATABASE LINK TO DBA
WITH ADMIN OPTION
/
GRANT DROP PUBLIC SYNONYM TO DBA
WITH ADMIN OPTION
/
GRANT DROP TABLESPACE TO DBA
WITH ADMIN OPTION
/
GRANT DROP USER TO DBA
WITH ADMIN OPTION
/
GRANT ENQUEUE ANY QUEUE TO DBA
WITH ADMIN OPTION
/
GRANT EXECUTE ANY INDEXTYPE TO DBA
WITH ADMIN OPTION
/
GRANT EXECUTE ANY LIBRARY TO DBA
WITH ADMIN OPTION
/
GRANT EXECUTE ANY OPERATOR TO DBA
WITH ADMIN OPTION
/
GRANT EXECUTE ANY PROCEDURE TO DBA
WITH ADMIN OPTION
/
GRANT FLASHBACK ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT GRANT ANY OBJECT PRIVILEGE TO DBA
WITH ADMIN OPTION
/
GRANT GRANT ANY PRIVILEGE TO DBA
WITH ADMIN OPTION
/
GRANT GRANT ANY ROLE TO DBA
WITH ADMIN OPTION
/
GRANT GRANT DEFAULT ROLE TO DBA
WITH ADMIN OPTION
/
GRANT INSERT ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT LOCK ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT MANAGE ANY QUEUE TO DBA
WITH ADMIN OPTION
/
GRANT SELECT ANY DICTIONARY TO DBA
WITH ADMIN OPTION
/
GRANT SELECT ANY SEQUENCE TO DBA
WITH ADMIN OPTION
/
GRANT SELECT ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT SYSDBA TO DBA
WITH ADMIN OPTION
/
GRANT UPDATE ANY TABLE TO DBA
WITH ADMIN OPTION
/
GRANT CREATE SESSION TO OUTLN
/
GRANT CREATE TABLE TO OUTLN
/
GRANT EXECUTE ANY PROCEDURE TO OUTLN
/
GRANT RESOURCE TO OUTLN
/
GRANT CREATE PROCEDURE TO RESOURCE
/
GRANT CREATE SEQUENCE TO RESOURCE
/
GRANT CREATE TABLE TO RESOURCE
/
GRANT CREATE TRIGGER TO RESOURCE
/
GRANT CONNECT TO SCOTT
/
GRANT RESOURCE TO SCOTT
/
GRANT SELECT ANY DICTIONARY TO SELECT_CATALOG_ROLE
/
GRANT CONNECT TO TIBERO
WITH ADMIN OPTION
/
GRANT DBA TO TIBERO
/
GRANT RESOURCE TO TIBERO
WITH ADMIN OPTION
/
GRANT CONNECT TO TIBERO1
WITH ADMIN OPTION
/
GRANT DBA TO TIBERO1
/
GRANT RESOURCE TO TIBERO1
WITH ADMIN OPTION
/
-- exporting public synonyms
CREATE OR REPLACE PUBLIC SYNONYM "CLIENT_ACCESS_POLICY" FOR "SYS"."CLIENT_ACCESS_POLICY"
/
CREATE OR REPLACE PUBLIC SYNONYM "_RESOURCE_MANAGER_PLAN_DIRECTIVES_INTERNAL" FOR "SYS"."_RESOURCE_MANAGER_PLAN_DIRECTIVES_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_RESOURCE_MANAGER_MONITOR_INTERNAL" FOR "SYS"."_RESOURCE_MANAGER_MONITOR_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_RESOURCE_MANAGER_AUDIT_INTERNAL" FOR "SYS"."_RESOURCE_MANAGER_AUDIT_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_AQ" FOR "SYS"."DBMS_AQ"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_AQADM" FOR "SYS"."DBMS_AQADM"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_ASSERT" FOR "SYS"."DBMS_ASSERT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_GEOM" FOR "SYS"."DBMS_GEOM"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_PARSED_ITEM" FOR "SYS"."KU$_PARSED_ITEM"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_PARSED_ITEMS" FOR "SYS"."KU$_PARSED_ITEMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_DDL" FOR "SYS"."KU$_DDL"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_DDLS" FOR "SYS"."KU$_DDLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_MULTI_DDL" FOR "SYS"."KU$_MULTI_DDL"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_MULTI_DDLS" FOR "SYS"."KU$_MULTI_DDLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_ERRORLINE" FOR "SYS"."KU$_ERRORLINE"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$ERRORLINES" FOR "SYS"."KU$_ERRORLINES"
/
CREATE OR REPLACE PUBLIC SYNONYM "KU$_SUBMITRESULTS" FOR "SYS"."KU$_SUBMITRESULTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_REDEFINITION" FOR "SYS"."DBMS_REDEFINITION"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_REDEFINITION_STATS" FOR "SYS"."DBMS_REDEFINITION_STATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SQL_TRANSLATOR" FOR "SYS"."DBMS_SQL_TRANSLATOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "SQLPROF_ATTR" FOR "SYS"."SQLPROF_ATTR"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SQLTUNE" FOR "SYS"."DBMS_SQLTUNE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SPM" FOR "SYS"."DBMS_SPM"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XPLAN" FOR "SYS"."DBMS_XPLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_FDS_CLASS" FOR "SYS"."HS_FDS_CLASS"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_FDS_INST" FOR "SYS"."HS_FDS_INST"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_BASE_CAPS" FOR "SYS"."HS_BASE_CAPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_CLASS_CAPS" FOR "SYS"."HS_CLASS_CAPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_INST_CAPS" FOR "SYS"."HS_INST_CAPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_BASE_DD" FOR "SYS"."HS_BASE_DD"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_CLASS_DD" FOR "SYS"."HS_CLASS_DD"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_INST_DD" FOR "SYS"."HS_INST_DD"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_CLASS_INIT" FOR "SYS"."HS_CLASS_INIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_INST_INIT" FOR "SYS"."HS_INST_INIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_ALL_CAPS" FOR "SYS"."HS_ALL_CAPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_ALL_DD" FOR "SYS"."HS_ALL_DD"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_ALL_INITS" FOR "SYS"."HS_ALL_INITS"
/
CREATE OR REPLACE PUBLIC SYNONYM "HS_FDS_CLASS_DATE" FOR "SYS"."HS_FDS_CLASS_DATE"
/
CREATE OR REPLACE PUBLIC SYNONYM "PLAN_TABLE" FOR "SYS"."PLAN_TABLE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_ACCESS" FOR "SYS"."_VT_ACCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_ACTIVE_SESSION_HISTORY" FOR "SYS"."_VT_ACTIVE_SESSION_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_AUTOTRACESTAT" FOR "SYS"."_VT_AUTOTRACESTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_BG_SESSION" FOR "SYS"."_VT_BG_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_BPARAMETER" FOR "SYS"."_VT_BPARAMETER"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_CCC_RSBSTAT" FOR "SYS"."_VT_CCC_RSBSTAT"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_CONTEXT" FOR "SYS"."_VT_CONTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_CWS_RSBSTAT" FOR "SYS"."_VT_CWS_RSBSTAT"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DATAFILE_BM" FOR "SYS"."_VT_DATAFILE_BM"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DBA_EXTENTS" FOR "SYS"."_VT_DBA_EXTENTS"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DBA_FREE_SPACE" FOR "SYS"."_VT_DBA_FREE_SPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DBA_UNDO_EXTENTS" FOR "SYS"."_VT_DBA_UNDO_EXTENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DBLINK" FOR "SYS"."_VT_DBLINK"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DBLINK_STATUS" FOR "SYS"."_VT_DBLINK_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DDCACHE" FOR "SYS"."_VT_DDCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DDCACHE_INFO" FOR "SYS"."_VT_DDCACHE_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DDCACHE_KEY_MAP_INFO" FOR "SYS"."_VT_DDCACHE_KEY_MAP_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DDCACHE_STAT" FOR "SYS"."_VT_DDCACHE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DD_SEARCH_KEY_NAME" FOR "SYS"."_VT_DD_SEARCH_KEY_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_DF_HINT" FOR "SYS"."_VT_DF_HINT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DUAL" FOR "SYS"."_VT_DUAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_ENABLEDPRIVS" FOR "SYS"."_VT_ENABLEDPRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_ENCRYPTION_WALLET" FOR "SYS"."_VT_ENCRYPTION_WALLET"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_EVENT_NAME" FOR "SYS"."_VT_EVENT_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_GLOBAL_TRANSACTION" FOR "SYS"."_VT_GLOBAL_TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_IM_SEGMENTS" FOR "SYS"."_VT_IM_SEGMENTS"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_INSTANCE" FOR "SYS"."_VT_INSTANCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_INSTANCEMETRIC" FOR "SYS"."_VT_INSTANCEMETRIC"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_INSTANCEMETRIC_HISTORY" FOR "SYS"."_VT_INSTANCEMETRIC_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_INTERCONNECTION" FOR "SYS"."_VT_INTERCONNECTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_INTERCONNECTS" FOR "SYS"."_VT_INTERCONNECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_INTERCONNECT_LATENCY" FOR "SYS"."_VT_INTERCONNECT_LATENCY"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT" FOR "SYS"."_VT_JCNTSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_BG_SESS_SIZE" FOR "SYS"."_VT_JCNTSTAT_BG_SESS_SIZE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_BG_SESS_TIME" FOR "SYS"."_VT_JCNTSTAT_BG_SESS_TIME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_BG_SESS_VALUE" FOR "SYS"."_VT_JCNTSTAT_BG_SESS_VALUE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_NAME" FOR "SYS"."_VT_JCNTSTAT_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_SAVE" FOR "SYS"."_VT_JCNTSTAT_SAVE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_SESS_SIZE" FOR "SYS"."_VT_JCNTSTAT_SESS_SIZE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_SESS_START" FOR "SYS"."_VT_JCNTSTAT_SESS_START"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_SESS_TIME" FOR "SYS"."_VT_JCNTSTAT_SESS_TIME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_SESS_VALUE" FOR "SYS"."_VT_JCNTSTAT_SESS_VALUE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_SIZE" FOR "SYS"."_VT_JCNTSTAT_SIZE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_TIME" FOR "SYS"."_VT_JCNTSTAT_TIME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_JCNTSTAT_VALUE" FOR "SYS"."_VT_JCNTSTAT_VALUE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_LATCH" FOR "SYS"."_VT_LATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_LATCH_SAVE" FOR "SYS"."_VT_LATCH_SAVE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_LICENSE" FOR "SYS"."_VT_LICENSE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_LISTENER_PORT" FOR "SYS"."_VT_LISTENER_PORT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_LPN_REPORT" FOR "SYS"."_VT_LPN_REPORT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_MEM_MGR" FOR "SYS"."_VT_MEM_MGR"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_METRIC" FOR "SYS"."_VT_METRIC"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_METRICNAME" FOR "SYS"."_VT_METRICNAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_MYSESSID" FOR "SYS"."_VT_MYSESSID"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_MYTID" FOR "SYS"."_VT_MYTID"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_NLS_PARAMETERS" FOR "SYS"."_VT_NLS_PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_NLS_SYS_PARAMETERS" FOR "SYS"."_VT_NLS_SYS_PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_OPEN_CURSOR" FOR "SYS"."_VT_OPEN_CURSOR"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_OPERATIONS" FOR "SYS"."_VT_OPERATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_OPERATION_STATS" FOR "SYS"."_VT_OPERATION_STATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_OSSTAT" FOR "SYS"."_VT_OSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_OSSTAT2" FOR "SYS"."_VT_OSSTAT2"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PARAMETER" FOR "SYS"."_VT_PARAMETER"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PATCH" FOR "SYS"."_VT_PATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PENDING_TRANSACTION" FOR "SYS"."_VT_PENDING_TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PE_PESSTAT" FOR "SYS"."_VT_PE_PESSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PE_PROCESS" FOR "SYS"."_VT_PE_PROCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PE_SESSION" FOR "SYS"."_VT_PE_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PE_SYSSTAT" FOR "SYS"."_VT_PE_SYSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PE_TQSTAT" FOR "SYS"."_VT_PE_TQSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PGASTAT" FOR "SYS"."_VT_PGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PGA_PROFILES" FOR "SYS"."_VT_PGA_PROFILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PPCACHE_STAT" FOR "SYS"."_VT_PPCACHE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_PROCINFO" FOR "SYS"."_VT_PROCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RESERVED_WORDS" FOR "SYS"."_VT_RESERVED_WORDS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RESULT_CACHE_DEPENDENCY" FOR "SYS"."_VT_RESULT_CACHE_DEPENDENCY"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RESULT_CACHE_OBJECTS" FOR "SYS"."_VT_RESULT_CACHE_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RESULT_CACHE_OBJECT_STATISTICS" FOR "SYS"."_VT_RESULT_CACHE_OBJECT_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RESULT_CACHE_STATISTICS" FOR "SYS"."_VT_RESULT_CACHE_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RSRC_CONSUMER_GROUP" FOR "SYS"."_VT_RSRC_CONSUMER_GROUP"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RSRC_PLAN" FOR "SYS"."_VT_RSRC_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RSRC_SESSION_INFO" FOR "SYS"."_VT_RSRC_SESSION_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_RUNNING_JOBS" FOR "SYS"."_VT_RUNNING_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SESSION" FOR "SYS"."_VT_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SESSION_EVENT" FOR "SYS"."_VT_SESSION_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SESSION_LONGOPS" FOR "SYS"."_VT_SESSION_LONGOPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SESS_ENABLED_ROLES" FOR "SYS"."_VT_SESS_ENABLED_ROLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SGASTAT" FOR "SYS"."_VT_SGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SHM" FOR "SYS"."_VT_SHM"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SHP_ADVICE" FOR "SYS"."_VT_SHP_ADVICE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SPINLOCK" FOR "SYS"."_VT_SPINLOCK"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SPINLOCK_HOLDER" FOR "SYS"."_VT_SPINLOCK_HOLDER"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SPINUSE_STAT" FOR "SYS"."_VT_SPINUSE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SQL_MONITOR" FOR "SYS"."_VT_SQL_MONITOR"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SQL_PLAN_MONITOR" FOR "SYS"."_VT_SQL_PLAN_MONITOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SQL_WORKAREA" FOR "SYS"."_VT_SQL_WORKAREA"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SQL_WORKAREA_HISTOGRAM" FOR "SYS"."_VT_SQL_WORKAREA_HISTOGRAM"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_STAT_DESC" FOR "SYS"."_VT_STAT_DESC"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SYSTEM_EVENT" FOR "SYS"."_VT_SYSTEM_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_SYSTEM_EVENT_SAVE" FOR "SYS"."_VT_SYSTEM_EVENT_SAVE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TEMPSGMT_OP_USAGE" FOR "SYS"."_VT_TEMPSGMT_OP_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TEMPSGMT_USAGE" FOR "SYS"."_VT_TEMPSGMT_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TEMPTS" FOR "SYS"."_VT_TEMPTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TEMP_GRANULE" FOR "SYS"."_VT_TEMP_GRANULE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_THRINFO" FOR "SYS"."_VT_THRINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_THR_ACT_INFO" FOR "SYS"."_VT_THR_ACT_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_THR_WAITSTAT" FOR "SYS"."_VT_THR_WAITSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TIMER" FOR "SYS"."_VT_TIMER"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TIMEZONE_NAMES" FOR "SYS"."_VT_TIMEZONE_NAMES"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TRANSACTION" FOR "SYS"."_VT_TRANSACTION"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TSN_TIME_MAP" FOR "SYS"."_VT_TSN_TIME_MAP"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_TX_RECOVERY_PROGRESS" FOR "SYS"."_VT_TX_RECOVERY_PROGRESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_USER_ROLE" FOR "SYS"."_VT_USER_ROLE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_USER_SQL_PLAN" FOR "SYS"."_VT_USER_SQL_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_USGMT_CACHE" FOR "SYS"."_VT_USGMT_CACHE"/
CREATE OR REPLACE PUBLIC SYNONYM "VT_USGMT_TXENTRY" FOR "SYS"."_VT_USGMT_TXENTRY"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_VERSION" FOR "SYS"."_VT_VERSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_VPD_PREDICATES" FOR "SYS"."_VT_VPD_PREDICATES"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WAITEVENT" FOR "SYS"."_VT_WAITEVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WAITEVENT_SESS_START" FOR "SYS"."_VT_WAITEVENT_SESS_START"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WAITEVENT_TYPE" FOR "SYS"."_VT_WAITEVENT_TYPE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WAITSTAT" FOR "SYS"."_VT_WAITSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WAIT_EVENT_DESC" FOR "SYS"."_VT_WAIT_EVENT_DESC"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WLOCK" FOR "SYS"."_VT_WLOCK"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WLOCK_STAT" FOR "SYS"."_VT_WLOCK_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_WLOCK_TYPE" FOR "SYS"."_VT_WLOCK_TYPE"
/
CREATE OR REPLACE PUBLIC SYNONYM "VT_XA_BRANCH" FOR "SYS"."_VT_XA_BRANCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "X$USER_ROLE" FOR "SYS"."X$USER_ROLE"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_OBJECTS_INTERNAL" FOR "SYS"."_SCHEDULER_OBJECTS_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_JOB_SEQ" FOR "SYS"."_SCHEDULER_JOB_SEQ"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_JOB_LOG_INTERNAL" FOR "SYS"."_SCHEDULER_JOB_LOG_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_RULE_CTX_INTERNAL" FOR "SYS"."_SCHEDULER_RULE_CTX_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_CHAIN_RULES_INTERNAL" FOR "SYS"."_SCHEDULER_CHAIN_RULES_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_STEP_CTX_INTERNAL" FOR "SYS"."_SCHEDULER_STEP_CTX_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_SCHEDULER_CHAIN_STEPS_INTERNAL" FOR "SYS"."_SCHEDULER_CHAIN_STEPS_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_RESOURCE_MANAGER_RESOURCE_PLANS_INTERNAL" FOR "SYS"."_RESOURCE_MANAGER_RESOURCE_PLANS_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "_RESOURCE_MANAGER_CONSUMER_GROUPS_INTERNAL" FOR "SYS"."_RESOURCE_MANAGER_CONSUMER_GROUPS_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_LOG_GROUPS" FOR "SYSCAT"."USER_LOG_GROUPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DATA_FILES" FOR "SYSCAT"."DBA_DATA_FILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DATAFILES" FOR "SYSCAT"."DBA_DATA_FILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TEMP_FILES" FOR "SYSCAT"."DBA_TEMP_FILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TEMPFILES" FOR "SYSCAT"."DBA_TEMP_FILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IDX_COLUMNS" FOR "SYSCAT"."DBA_IDX_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IND_COLUMNS" FOR "SYSCAT"."DBA_IDX_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IDX_COLUMNS" FOR "SYSCAT"."ALL_IDX_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IND_COLUMNS" FOR "SYSCAT"."ALL_IDX_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IDX_COLUMNS" FOR "SYSCAT"."USER_IDX_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IND_COLUMNS" FOR "SYSCAT"."USER_IDX_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IDX_COLUMNS_INFO" FOR "SYSCAT"."ALL_IDX_COLUMNS_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IDX_AND_LOB_COLUMNS_INFO" FOR "SYSCAT"."ALL_IDX_AND_LOB_COLUMNS_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IDX_EXPRESSIONS" FOR "SYSCAT"."DBA_IDX_EXPRESSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IND_EXPRESSIONS" FOR "SYSCAT"."DBA_IDX_EXPRESSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IDX_EXPRESSIONS" FOR "SYSCAT"."ALL_IDX_EXPRESSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IND_EXPRESSIONS" FOR "SYSCAT"."ALL_IDX_EXPRESSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IDX_EXPRESSIONS" FOR "SYSCAT"."USER_IDX_EXPRESSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IND_EXPRESSIONS" FOR "SYSCAT"."USER_IDX_EXPRESSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_INDEXES" FOR "SYSCAT"."DBA_INDEXES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_INDEXES" FOR "SYSCAT"."ALL_INDEXES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_INDEXES" FOR "SYSCAT"."USER_INDEXES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_OBJECTS" FOR "SYSCAT"."DBA_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_OBJECTS" FOR "SYSCAT"."ALL_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_OBJECTS" FOR "SYSCAT"."USER_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_ROLES" FOR "SYSCAT"."DBA_ROLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_ROLE_PRIVS" FOR "SYSCAT"."DBA_ROLE_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_ROLE_PRIVS" FOR "SYSCAT"."USER_ROLE_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "SYS_OBJECTS" FOR "SYSCAT"."SYS_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SEGMENTS" FOR "SYSCAT"."DBA_SEGMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SEGMENTS" FOR "SYSCAT"."ALL_SEGMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SEGMENTS" FOR "SYSCAT"."USER_SEGMENTS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_UNDO_SGMTS" FOR "SYSCAT"."DBA_UNDO_SGMTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_ROLLBACK_SEGS" FOR "SYSCAT"."DBA_UNDO_SGMTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SYNONYMS" FOR "SYSCAT"."DBA_SYNONYMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SYNONYMS" FOR "SYSCAT"."ALL_SYNONYMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SYNONYMS" FOR "SYSCAT"."USER_SYNONYMS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SYS_PRIVS" FOR "SYSCAT"."DBA_SYS_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SYS_PRIVS" FOR "SYSCAT"."USER_SYS_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_COL_STATISTICS" FOR "SYSCAT"."DBA_TBL_COL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_COL_STATISTICS" FOR "SYSCAT"."DBA_TBL_COL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_COL_STATISTICS" FOR "SYSCAT"."ALL_TBL_COL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_COL_STATISTICS" FOR "SYSCAT"."ALL_TBL_COL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_COL_STATISTICS" FOR "SYSCAT"."USER_TBL_COL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_COL_STATISTICS" FOR "SYSCAT"."USER_TBL_COL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_COLUMNS" FOR "SYSCAT"."DBA_TBL_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_COLUMNS" FOR "SYSCAT"."DBA_TBL_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_COLUMNS_WITH_DNO" FOR "SYSCAT"."ALL_TBL_COLUMNS_WITH_DNO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_COLUMNS" FOR "SYSCAT"."ALL_TBL_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_COLUMNS" FOR "SYSCAT"."ALL_TBL_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_COLUMNS" FOR "SYSCAT"."USER_TBL_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_COLUMNS" FOR "SYSCAT"."USER_TBL_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_COLS" FOR "SYSCAT"."DBA_TBL_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_COLS" FOR "SYSCAT"."DBA_TBL_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_ALIAS" FOR "SYS"."V$AS_ALIAS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_DISK" FOR "SYS"."V$AS_DISK"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_DISKSPACE" FOR "SYS"."V$AS_DISKSPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_FILE" FOR "SYS"."V$AS_FILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_USER" FOR "SYS"."V$AS_USER"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_EXTENT_MAP" FOR "SYS"."V$AS_EXTENT_MAP"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_DISK_HISTORY" FOR "SYS"."V$AS_DISK_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_OPERATION" FOR "SYS"."V$AS_OPERATION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_USERGROUP" FOR "SYS"."V$AS_USERGROUP"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AS_USERGROUP_MEMBER" FOR "SYS"."V$AS_USERGROUP_MEMBER"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_CLIENT" FOR "SYS"."V$SSVR_CLIENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_STORAGE_DISK" FOR "SYS"."V$SSVR_STORAGE_DISK"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_GRID_DISK" FOR "SYS"."V$SSVR_GRID_DISK"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_FLASHCACHE" FOR "SYS"."V$SSVR_FLASHCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_SLAB_STAT" FOR "SYS"."V$SSVR_SLAB_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_IOSTAT" FOR "SYS"."V$SSVR_IOSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_IOLOAD" FOR "SYS"."V$SSVR_IOLOAD"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_MEMSTAT" FOR "SYS"."V$SSVR_MEMSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_IORM_CATEGORY_PLAN" FOR "SYS"."V$SSVR_IORM_CATEGORY_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SSVR_IORM_DB_PLAN" FOR "SYS"."V$SSVR_IORM_DB_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DATABASE" FOR "SYS"."V$DATABASE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DATAFILE" FOR "SYS"."V$DATAFILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$MEMORY_TABLESPACE" FOR "SYS"."V$MEMORY_TABLESPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TEMPFILE" FOR "SYS"."V$TEMPFILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DBFILE" FOR "SYS"."V$DBFILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DATAFILE_HEADER" FOR "SYS"."V$DATAFILE_HEADER"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$FILESTAT" FOR "SYS"."V$FILESTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TEMPSTAT" FOR "SYS"."V$TEMPSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TEMPSEG_USAGE" FOR "SYS"."V$TEMPSEG_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TEMPSEG_OP_USAGE" FOR "SYS"."V$TEMPSEG_OP_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TABLESPACE" FOR "SYS"."V$TABLESPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$CONTROLFILE" FOR "SYS"."V$CONTROLFILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BACKUP" FOR "SYS"."V$BACKUP"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BACKUP_SET" FOR "SYS"."V$BACKUP_SET"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BACKUP_ARCHIVED_LOG" FOR "SYS"."V$BACKUP_ARCHIVED_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LOG" FOR "SYS"."V$LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LOGFILE" FOR "SYS"."V$LOGFILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ARCHIVED_LOG" FOR "SYS"."V$ARCHIVED_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ARCHIVE_DEST_FILES" FOR "SYS"."V$ARCHIVE_DEST_FILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LOG_HISTORY" FOR "SYS"."V$LOG_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LOG_HISTORY" FOR "SYS"."GV$LOG_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$FLASHBACK_LOG" FOR "SYS"."V$FLASHBACK_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$FLASHBACK_ARCHIVED_LOG" FOR "SYS"."V$FLASHBACK_ARCHIVED_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$FLASHBACK_MARKER" FOR "SYS"."V$FLASHBACK_MARKER"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RECOVER_FILE" FOR "SYS"."V$RECOVER_FILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RECOVERY_FILE_STATUS" FOR "SYS"."V$RECOVERY_FILE_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RECOVERY_STATUS" FOR "SYS"."V$RECOVERY_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BUFFER_POOL" FOR "SYS"."V$BUFFER_POOL"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BUFFER_POOL_STATISTICS" FOR "SYS"."V$BUFFER_POOL_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$UNDOSTAT" FOR "SYS"."V$UNDOSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ROLLSTAT" FOR "SYS"."V$ROLLSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TRANSACTION" FOR "SYS"."V$TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$CORRUPT_XID" FOR "SYS"."V$CORRUPT_XID"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LATCH" FOR "SYS"."V$LATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LOCK" FOR "SYS"."V$LOCK"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$EVENT_NAME" FOR "SYS"."V$EVENT_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$THR_EVENT" FOR "SYS"."V$THR_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESSION_EVENT" FOR "SYS"."V$SESSION_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SYSTEM_EVENT" FOR "SYS"."V$SYSTEM_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESSION_WAIT" FOR "SYS"."V$SESSION_WAIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ENQUEUE_STAT" FOR "SYS"."V$ENQUEUE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TIMER" FOR "SYS"."V$TIMER"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SGA" FOR "SYS"."V$SGA"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SGASTAT" FOR "SYS"."V$SGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SHP_ADVICE" FOR "SYS"."V$SHP_ADVICE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ACTIVE_SESSION_HISTORY" FOR "SYS"."V$ACTIVE_SESSION_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$METRIC" FOR "SYS"."V$METRIC"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PROCESS" FOR "SYS"."V$PROCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESSTAT" FOR "SYS"."V$SESSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BG_SESSTAT" FOR "SYS"."V$BG_SESSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESSION_IO" FOR "SYS"."V$SESSION_IO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$MYSTAT" FOR "SYS"."V$MYSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_PLAN" FOR "SYS"."V$SQL_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_PLAN_STATISTICS" FOR "SYS"."V$SQL_PLAN_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLTEXT" FOR "SYS"."V$SQLTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLTEXT_WITH_NEWLINES" FOR "SYS"."V$SQLTEXT_WITH_NEWLINES"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLTEXT2" FOR "SYS"."V$SQLTEXT2"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLTEXT_WITH_NEWLINES2" FOR "SYS"."V$SQLTEXT_WITH_NEWLINES2"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PROXY_SQLTEXT" FOR "SYS"."V$PROXY_SQLTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PROXY_SQL_PARAM" FOR "SYS"."V$PROXY_SQL_PARAM"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$STATNAME" FOR "SYS"."V$STATNAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$FILESTAT" FOR "SYS"."GV$FILESTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TEMPSTAT" FOR "SYS"."GV$TEMPSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ALL_FILESTAT" FOR "SYS"."GV$ALL_FILESTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SEGMENT_STATISTICS" FOR "SYS"."GV$SEGMENT_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TEMPSEG_USAGE" FOR "SYS"."GV$TEMPSEG_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TEMPSEG_OP_USAGE" FOR "SYS"."GV$TEMPSEG_OP_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$CHECKPOINT" FOR "SYS"."GV$CHECKPOINT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$UNDOSTAT" FOR "SYS"."GV$UNDOSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ROLLSTAT" FOR "SYS"."GV$ROLLSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TRANSACTION" FOR "SYS"."GV$TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$CORRUPT_XID" FOR "SYS"."GV$CORRUPT_XID"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LATCH" FOR "SYS"."GV$LATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SPINLOCK_HOLDER" FOR "SYS"."GV$SPINLOCK_HOLDER"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$THR_EVENT" FOR "SYS"."GV$THR_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESSION_EVENT" FOR "SYS"."GV$SESSION_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SYSTEM_EVENT" FOR "SYS"."GV$SYSTEM_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESSION_WAIT" FOR "SYS"."GV$SESSION_WAIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$WAITSTAT" FOR "SYS"."GV$WAITSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ENQUEUE_STAT" FOR "SYS"."GV$ENQUEUE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TIMER" FOR "SYS"."GV$TIMER"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SGA" FOR "SYS"."GV$SGA"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SHP_ADVICE" FOR "SYS"."GV$SHP_ADVICE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ACTIVE_SESSION_HISTORY" FOR "SYS"."GV$ACTIVE_SESSION_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$METRIC" FOR "SYS"."GV$METRIC"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PROCESS" FOR "SYS"."GV$PROCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESSTAT" FOR "SYS"."GV$SESSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$BG_SESSTAT" FOR "SYS"."GV$BG_SESSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$DB_PIPES" FOR "SYS"."GV$DB_PIPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESSION_IO" FOR "SYS"."GV$SESSION_IO"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_PLAN" FOR "SYS"."GV$SQL_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_PLAN_STATISTICS" FOR "SYS"."GV$SQL_PLAN_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLTEXT" FOR "SYS"."GV$SQLTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLTEXT_WITH_NEWLINES" FOR "SYS"."GV$SQLTEXT_WITH_NEWLINES"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLTEXT2" FOR "SYS"."GV$SQLTEXT2"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLTEXT_WITH_NEWLINES2" FOR "SYS"."GV$SQLTEXT_WITH_NEWLINES2"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SYSSTAT" FOR "SYS"."GV$SYSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SYSSTAT_VALUE" FOR "SYS"."GV$SYSSTAT_VALUE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TACSTAT" FOR "SYS"."GV$TACSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PROXY_SQLTEXT" FOR "SYS"."GV$PROXY_SQLTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PROXY_SQL_PARAM" FOR "SYS"."GV$PROXY_SQL_PARAM"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESSION" FOR "SYS"."GV$SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$BG_SESSION" FOR "SYS"."GV$BG_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RUNNING_JOBS" FOR "SYS"."GV$RUNNING_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RUNNING_JOBS_WITH_NAME" FOR "SYS"."GV$RUNNING_JOBS_WITH_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LICENSE" FOR "SYS"."GV$LICENSE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ENCRYPTION_WALLET" FOR "SYS"."GV$ENCRYPTION_WALLET"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PGASTAT" FOR "SYS"."GV$PGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ACCESS" FOR "SYS"."GV$ACCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LIBRARYCACHE" FOR "SYS"."GV$LIBRARYCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$ROWCACHE" FOR "SYS"."GV$ROWCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLSTATS" FOR "SYS"."GV$SQLSTATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLSTATS_PLAN_HASH" FOR "SYS"."GV$SQLSTATS_PLAN_HASH"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQLAREA" FOR "SYS"."GV$SQLAREA"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL" FOR "SYS"."GV$SQL"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$GLOBAL_TRANSACTION" FOR "SYS"."GV$GLOBAL_TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$DBLINK" FOR "SYS"."GV$DBLINK"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$DBLINK_STATUS" FOR "SYS"."GV$DBLINK_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TSN_TIME" FOR "SYS"."GV$TSN_TIME"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$INSTANCE" FOR "SYS"."GV$INSTANCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PE_SESSION" FOR "SYS"."GV$PE_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PE_PROCESS" FOR "SYS"."GV$PE_PROCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESSION_LONGOPS" FOR "SYS"."GV$SESSION_LONGOPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$OPEN_CURSOR" FOR "SYS"."GV$OPEN_CURSOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$INSTANCEMETRIC" FOR "SYS"."GV$INSTANCEMETRIC"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$INSTANCEMETRIC_HISTORY" FOR "SYS"."GV$INSTANCEMETRIC_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$CLUSTER_INTERCONNECTS" FOR "SYS"."GV$CLUSTER_INTERCONNECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$INTERCONNECT_LATENCY" FOR "SYS"."GV$INTERCONNECT_LATENCY"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$INTERCONNECTION" FOR "SYS"."GV$INTERCONNECTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RSBSTAT" FOR "SYS"."GV$RSBSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$VERSION" FOR "SYS"."GV$VERSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PATCH" FOR "SYS"."GV$PATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_EXPC_INFO" FOR "SYS"."GV$SQL_EXPC_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$OSSTAT" FOR "SYS"."GV$OSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$OSSTAT2" FOR "SYS"."GV$OSSTAT2"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$AUTO_COALESCE" FOR "SYS"."GV$AUTO_COALESCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$IM_SEGMENTS" FOR "SYS"."GV$IM_SEGMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RESULT_CACHE_DEPENDENCY" FOR "SYS"."GV$RESULT_CACHE_DEPENDENCY"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RESULT_CACHE_OBJECTS" FOR "SYS"."GV$RESULT_CACHE_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RESULT_CACHE_STATISTICS" FOR "SYS"."GV$RESULT_CACHE_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RESULT_CACHE_OBJECT_STATISTICS" FOR "SYS"."GV$RESULT_CACHE_OBJECT_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_BIND_CAPTURE_ALL" FOR "SYS"."GV$SQL_BIND_CAPTURE_ALL"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_BIND_CAPTURE" FOR "SYS"."GV$SQL_BIND_CAPTURE"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_WORKAREA" FOR "SYS"."GV$SQL_WORKAREA"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SQL_WORKAREA_HISTOGRAM" FOR "SYS"."GV$SQL_WORKAREA_HISTOGRAM"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$THR_ACT_INFO" FOR "SYS"."GV$THR_ACT_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SESS_TIME_MODEL" FOR "SYS"."GV$SESS_TIME_MODEL"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SYS_TIME_MODEL" FOR "SYS"."GV$SYS_TIME_MODEL"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RSRC_PLAN" FOR "SYS"."GV$RSRC_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RSRC_CONSUMER_GROUP" FOR "SYS"."GV$RSRC_CONSUMER_GROUP"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$RSRC_SESSION_INFO" FOR "SYS"."GV$RSRC_SESSION_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$MEM_MGR" FOR "SYS"."GV$MEM_MGR"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$OUTLINE" FOR "SYS"."GV$OUTLINE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SYSSTAT" FOR "SYS"."V$SYSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SYSSTAT_VALUE" FOR "SYS"."V$SYSSTAT_VALUE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESSION" FOR "SYS"."V$SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BG_SESSION" FOR "SYS"."V$BG_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RUNNING_JOBS" FOR "SYS"."V$RUNNING_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RUNNING_JOBS_WITH_NAME" FOR "SYS"."V$RUNNING_JOBS_WITH_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ACCESS" FOR "SYS"."V$ACCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PGASTAT" FOR "SYS"."V$PGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LIBRARYCACHE" FOR "SYS"."V$LIBRARYCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ROWCACHE" FOR "SYS"."V$ROWCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLSTATS" FOR "SYS"."V$SQLSTATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLSTATS_PLAN_HASH" FOR "SYS"."V$SQLSTATS_PLAN_HASH"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQLAREA" FOR "SYS"."V$SQLAREA"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL" FOR "SYS"."V$SQL"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$GLOBAL_TRANSACTION" FOR "SYS"."V$GLOBAL_TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$IPARAM_DESC" FOR "SYS"."V$IPARAM_DESC"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PARAMETERS" FOR "SYS"."V$PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SYSTEM_PARAMETERS" FOR "SYS"."V$SYSTEM_PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DBLINK" FOR "SYS"."V$DBLINK"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$STANDBY_LOGFILE" FOR "SYS"."V$STANDBY_LOGFILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$STANDBY_LOG" FOR "SYS"."V$STANDBY_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$STANDBY_DEST" FOR "SYS"."V$STANDBY_DEST"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$STANDBY_STATUS" FOR "SYS"."V$STANDBY_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$STANDBY" FOR "SYS"."V$STANDBY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RECOVERY_PROGRESS" FOR "SYS"."V$RECOVERY_PROGRESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TSN_TIME" FOR "SYS"."V$TSN_TIME"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$INSTANCE" FOR "SYS"."V$INSTANCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PE_TQSTAT" FOR "SYS"."V$PE_TQSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PE_SESSION" FOR "SYS"."V$PE_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PE_PESSTAT" FOR "SYS"."V$PE_PESSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PE_PESPLAN" FOR "SYS"."V$PE_PESPLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PE_PROCESS" FOR "SYS"."V$PE_PROCESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PE_SYSSTAT" FOR "SYS"."V$PE_SYSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$OPEN_CURSOR" FOR "SYS"."V$OPEN_CURSOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$INSTANCEMETRIC" FOR "SYS"."V$INSTANCEMETRIC"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$INSTANCEMETRIC_HISTORY" FOR "SYS"."V$INSTANCEMETRIC_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RESERVED_WORDS" FOR "SYS"."V$RESERVED_WORDS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$VERSION" FOR "SYS"."V$VERSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_EXPC_INFO" FOR "SYS"."V$SQL_EXPC_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$OSSTAT" FOR "SYS"."V$OSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$UNDO_FREE_SPACE" FOR "SYS"."V$UNDO_FREE_SPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$TIMEZONE_NAMES" FOR "SYS"."V$TIMEZONE_NAMES"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$AUTO_COALESCE" FOR "SYS"."V$AUTO_COALESCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$IM_SEGMENTS" FOR "SYS"."V$IM_SEGMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$BLOCKER_SESSION" FOR "SYS"."V$BLOCKER_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$WAITER_SESSION" FOR "SYS"."V$WAITER_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RESULT_CACHE_DEPENDENCY" FOR "SYS"."V$RESULT_CACHE_DEPENDENCY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RESULT_CACHE_OBJECTS" FOR "SYS"."V$RESULT_CACHE_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RESULT_CACHE_STATISTICS" FOR "SYS"."V$RESULT_CACHE_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RESULT_CACHE_OBJECT_STATISTICS" FOR "SYS"."V$RESULT_CACHE_OBJECT_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$CHECKPOINT" FOR "SYS"."V$CHECKPOINT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LICENSE" FOR "SYS"."V$LICENSE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DBLINK_STATUS" FOR "SYS"."V$DBLINK_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ENCRYPTION_WALLET" FOR "SYS"."V$ENCRYPTION_WALLET"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$OSSTAT2" FOR "SYS"."V$OSSTAT2"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SEGMENT_STATISTICS" FOR "SYS"."V$SEGMENT_STATISTICS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESSION_LONGOPS" FOR "SYS"."V$SESSION_LONGOPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SPINUSE_STAT" FOR "SYS"."V$SPINUSE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_BIND_CAPTURE_ALL" FOR "SYS"."V$SQL_BIND_CAPTURE_ALL"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$WAITSTAT" FOR "SYS"."V$WAITSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$WAITUSE_STAT" FOR "SYS"."V$WAITUSE_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$WAITUSE_THR_STAT" FOR "SYS"."V$WAITUSE_THR_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$ALL_FILESTAT" FOR "SYS"."V$ALL_FILESTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$CLUSTER_INTERCONNECTS" FOR "SYS"."V$CLUSTER_INTERCONNECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$INTERCONNECT_LATENCY" FOR "SYS"."V$INTERCONNECT_LATENCY"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$PGA_PROFILES" FOR "SYS"."V$PGA_PROFILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_BIND_CAPTURE" FOR "SYS"."V$SQL_BIND_CAPTURE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$CONTEXT" FOR "SYS"."V$CONTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DB_PIPES" FOR "SYS"."V$DB_PIPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DDCACHE_INFO" FOR "SYS"."V$DDCACHE_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$DDCACHE_KEY_MAP_INFO" FOR "SYS"."V$DDCACHE_KEY_MAP_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$THR_ACT_INFO" FOR "SYS"."V$THR_ACT_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_MONITOR" FOR "SYS"."V$SQL_MONITOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_PLAN_MONITOR" FOR "SYS"."V$SQL_PLAN_MONITOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_WORKAREA" FOR "SYS"."V$SQL_WORKAREA"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SQL_WORKAREA_HISTOGRAM" FOR "SYS"."V$SQL_WORKAREA_HISTOGRAM"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$VPD_POLICY" FOR "SYS"."V$VPD_POLICY"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$TEMP_EXTENT_POOL" FOR "SYS"."GV$TEMP_EXTENT_POOL"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SESS_TIME_MODEL" FOR "SYS"."V$SESS_TIME_MODEL"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SYS_TIME_MODEL" FOR "SYS"."V$SYS_TIME_MODEL"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LOCK" FOR "SYS"."GV$LOCK"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$PARAMETERS" FOR "SYS"."GV$PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$THRINFO" FOR "SYS"."V$THRINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$THRINFO" FOR "SYS"."GV$THRINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RSRC_PLAN" FOR "SYS"."V$RSRC_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RSRC_CONSUMER_GROUP" FOR "SYS"."V$RSRC_CONSUMER_GROUP"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$RSRC_SESSION_INFO" FOR "SYS"."V$RSRC_SESSION_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$NLS_PARAMETERS" FOR "SYS"."V$NLS_PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LOCKED_OBJECT" FOR "SYS"."V$LOCKED_OBJECT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LOCKED_OBJECT" FOR "SYS"."GV$LOCKED_OBJECT"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SLOG" FOR "SYS"."V$SLOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$SLOG" FOR "SYS"."GV$SLOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$OUTLINE" FOR "SYS"."V$OUTLINE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SERVER_EVENT_TYPE" FOR "SYS"."V$SERVER_EVENT_TYPE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SERVER_EVENT_SUBTYPE" FOR "SYS"."V$SERVER_EVENT_SUBTYPE"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$SERVER_EVENT_STATUS" FOR "SYS"."V$SERVER_EVENT_STATUS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$LISTENER_PORT" FOR "SYS"."V$LISTENER_PORT"
/
CREATE OR REPLACE PUBLIC SYNONYM "GV$LISTENER_PORT" FOR "SYS"."GV$LISTENER_PORT"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_COLS" FOR "SYSCAT"."ALL_TBL_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_COLS" FOR "SYSCAT"."ALL_TBL_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_COLS" FOR "SYSCAT"."USER_TBL_COLS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_COLS" FOR "SYSCAT"."USER_TBL_COLS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_IDENTITY_COLS" FOR "SYSCAT"."DBA_TAB_IDENTITY_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_IDENTITY_COLS" FOR "SYSCAT"."ALL_TAB_IDENTITY_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_IDENTITY_COLS" FOR "SYSCAT"."USER_TAB_IDENTITY_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_HISTOGRAMS" FOR "SYSCAT"."DBA_TBL_HISTOGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_HISTOGRAMS" FOR "SYSCAT"."DBA_TBL_HISTOGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_HISTOGRAMS" FOR "SYSCAT"."ALL_TBL_HISTOGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_HISTOGRAMS" FOR "SYSCAT"."ALL_TBL_HISTOGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_HISTOGRAMS" FOR "SYSCAT"."USER_TBL_HISTOGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_HISTOGRAMS" FOR "SYSCAT"."USER_TBL_HISTOGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_PRIVS" FOR "SYSCAT"."DBA_TBL_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_PRIVS" FOR "SYSCAT"."DBA_TBL_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_PRIVS" FOR "SYSCAT"."ALL_TBL_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_PRIVS" FOR "SYSCAT"."ALL_TBL_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_PRIVS" FOR "SYSCAT"."USER_TBL_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_PRIVS" FOR "SYSCAT"."USER_TBL_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_PRIVS_MADE" FOR "SYSCAT"."ALL_TBL_PRIVS_MADE"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_PRIVS_MADE" FOR "SYSCAT"."ALL_TBL_PRIVS_MADE"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_PRIVS_MADE" FOR "SYSCAT"."USER_TBL_PRIVS_MADE"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_PRIVS_MADE" FOR "SYSCAT"."USER_TBL_PRIVS_MADE"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_PRIVS_RECD" FOR "SYSCAT"."ALL_TBL_PRIVS_RECD"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_PRIVS_RECD" FOR "SYSCAT"."ALL_TBL_PRIVS_RECD"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_PRIVS_RECD" FOR "SYSCAT"."USER_TBL_PRIVS_RECD"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_PRIVS_RECD" FOR "SYSCAT"."USER_TBL_PRIVS_RECD"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TABLES" FOR "SYSCAT"."DBA_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TABLES" FOR "SYSCAT"."ALL_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TABLES" FOR "SYSCAT"."USER_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TABLESPACES" FOR "SYSCAT"."DBA_TABLESPACES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TABLESPACES" FOR "SYSCAT"."USER_TABLESPACES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_USERS" FOR "SYSCAT"."DBA_USERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_USERS" FOR "SYSCAT"."ALL_USERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_USERS" FOR "SYSCAT"."USER_USERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_PARTITIONS" FOR "SYSCAT"."DBA_TBL_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_PARTITIONS" FOR "SYSCAT"."DBA_TBL_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_PARTITIONS" FOR "SYSCAT"."ALL_TBL_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_PARTITIONS" FOR "SYSCAT"."ALL_TBL_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_PARTITIONS" FOR "SYSCAT"."USER_TBL_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_PARTITIONS" FOR "SYSCAT"."USER_TBL_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SUBPARTITION_TEMPLATES" FOR "SYSCAT"."DBA_SUBPARTITION_TEMPLATES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SUBPARTITION_TEMPLATES" FOR "SYSCAT"."ALL_SUBPARTITION_TEMPLATES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SUBPARTITION_TEMPLATES" FOR "SYSCAT"."USER_SUBPARTITION_TEMPLATES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IDX_PARTITIONS" FOR "SYSCAT"."DBA_IDX_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IND_PARTITIONS" FOR "SYSCAT"."DBA_IDX_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IDX_PARTITIONS" FOR "SYSCAT"."ALL_IDX_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IND_PARTITIONS" FOR "SYSCAT"."ALL_IDX_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IDX_PARTITIONS" FOR "SYSCAT"."USER_IDX_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IND_PARTITIONS" FOR "SYSCAT"."USER_IDX_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LOB_PARTITIONS" FOR "SYSCAT"."DBA_LOB_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_LOB_PARTITIONS" FOR "SYSCAT"."ALL_LOB_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_LOB_PARTITIONS" FOR "SYSCAT"."USER_LOB_PARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_SUBPARTITIONS" FOR "SYSCAT"."DBA_TBL_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_SUBPARTITIONS" FOR "SYSCAT"."DBA_TBL_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_SUBPARTITIONS" FOR "SYSCAT"."ALL_TBL_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_SUBPARTITIONS" FOR "SYSCAT"."ALL_TBL_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_SUBPARTITIONS" FOR "SYSCAT"."USER_TBL_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_SUBPARTITIONS" FOR "SYSCAT"."USER_TBL_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IDX_SUBPARTITIONS" FOR "SYSCAT"."DBA_IDX_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_IND_SUBPARTITIONS" FOR "SYSCAT"."DBA_IDX_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IDX_SUBPARTITIONS" FOR "SYSCAT"."ALL_IDX_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_IND_SUBPARTITIONS" FOR "SYSCAT"."ALL_IDX_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IDX_SUBPARTITIONS" FOR "SYSCAT"."USER_IDX_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_IND_SUBPARTITIONS" FOR "SYSCAT"."USER_IDX_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LOB_SUBPARTITIONS" FOR "SYSCAT"."DBA_LOB_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_LOB_SUBPARTITIONS" FOR "SYSCAT"."ALL_LOB_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_LOB_SUBPARTITIONS" FOR "SYSCAT"."USER_LOB_SUBPARTITIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_VIEWS" FOR "SYSCAT"."DBA_VIEWS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_VIEWS_INTERNAL" FOR "SYSCAT"."ALL_VIEWS_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_VIEWS" FOR "SYSCAT"."ALL_VIEWS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_VIEWS" FOR "SYSCAT"."USER_VIEWS"
/
CREATE OR REPLACE PUBLIC SYNONYM "SYNONYMS" FOR "SYSCAT"."SYNONYMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "PUBLICSYN" FOR "SYSCAT"."PUBLICSYN"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_UPDATABLE_COLUMNS" FOR "SYSCAT"."DBA_UPDATABLE_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_UPDATABLE_COLUMNS" FOR "SYSCAT"."ALL_UPDATABLE_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_UPDATABLE_COLUMNS" FOR "SYSCAT"."USER_UPDATABLE_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_ERRORS" FOR "SYSCAT"."DBA_ERRORS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_ERRORS" FOR "SYSCAT"."ALL_ERRORS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_ERRORS" FOR "SYSCAT"."USER_ERRORS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DEPENDENCIES" FOR "SYSCAT"."DBA_DEPENDENCIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_DEPENDENCIES" FOR "SYSCAT"."ALL_DEPENDENCIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_DEPENDENCIES" FOR "SYSCAT"."USER_DEPENDENCIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SOURCE" FOR "SYSCAT"."DBA_SOURCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SOURCE" FOR "SYSCAT"."ALL_SOURCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SOURCE" FOR "SYSCAT"."USER_SOURCE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SEQUENCES" FOR "SYSCAT"."DBA_SEQUENCES"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SEQUENCES" FOR "SYSCAT"."ALL_SEQUENCES"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SEQUENCES" FOR "SYSCAT"."USER_SEQUENCES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LOBS" FOR "SYSCAT"."DBA_LOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_LOBS" FOR "SYSCAT"."ALL_LOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_LOBS" FOR "SYSCAT"."USER_LOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TAB_COMMENTS" FOR "SYSCAT"."DBA_TAB_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TBL_COMMENTS" FOR "SYSCAT"."DBA_TAB_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_COL_COMMENTS" FOR "SYSCAT"."DBA_COL_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TAB_COMMENTS" FOR "SYSCAT"."ALL_TAB_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TBL_COMMENTS" FOR "SYSCAT"."ALL_TAB_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_COL_COMMENTS" FOR "SYSCAT"."ALL_COL_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TAB_COMMENTS" FOR "SYSCAT"."USER_TAB_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TBL_COMMENTS" FOR "SYSCAT"."USER_TAB_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_COL_COMMENTS" FOR "SYSCAT"."USER_COL_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_MVIEW_COMMENTS" FOR "SYSCAT"."DBA_MVIEW_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_MVIEW_COMMENTS" FOR "SYSCAT"."ALL_MVIEW_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_MVIEW_COMMENTS" FOR "SYSCAT"."USER_MVIEW_COMMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PART_TABLES" FOR "SYSCAT"."DBA_PART_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PART_TABLES" FOR "SYSCAT"."USER_PART_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PART_TABLES" FOR "SYSCAT"."ALL_PART_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PART_INDEXES" FOR "SYSCAT"."DBA_PART_INDEXES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PART_INDEXES" FOR "SYSCAT"."USER_PART_INDEXES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PART_INDEXES" FOR "SYSCAT"."ALL_PART_INDEXES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PART_LOBS" FOR "SYSCAT"."DBA_PART_LOBS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PART_LOBS" FOR "SYSCAT"."ALL_PART_LOBS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PART_LOBS" FOR "SYSCAT"."USER_PART_LOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_2PC_PENDING" FOR "SYSCAT"."DBA_2PC_PENDING"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_2PC_NEIGHBORS" FOR "SYSCAT"."DBA_2PC_NEIGHBORS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DB_LINKS" FOR "SYSCAT"."DBA_DB_LINKS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_DB_LINKS" FOR "SYSCAT"."ALL_DB_LINKS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_DB_LINKS" FOR "SYSCAT"."USER_DB_LINKS"/
CREATE OR REPLACE PUBLIC SYNONYM "SESSION_ROLES" FOR "SYSCAT"."SESSION_ROLES"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_FREE_SPACE" FOR "SYSCAT"."DBA_FREE_SPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_FREE_SPACE" FOR "SYSCAT"."USER_FREE_SPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PART_KEY_COLUMNS" FOR "SYSCAT"."DBA_PART_KEY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PART_KEY_COLUMNS" FOR "SYSCAT"."ALL_PART_KEY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PART_KEY_COLUMNS" FOR "SYSCAT"."USER_PART_KEY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SUBPART_KEY_COLUMNS" FOR "SYSCAT"."DBA_SUBPART_KEY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SUBPART_KEY_COLUMNS" FOR "SYSCAT"."ALL_SUBPART_KEY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SUBPART_KEY_COLUMNS" FOR "SYSCAT"."USER_SUBPART_KEY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "NLS_SESSION_PARAMETERS" FOR "SYSCAT"."NLS_SESSION_PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "NLS_DATABASE_PARAMETERS" FOR "SYSCAT"."NLS_DATABASE_PARAMETERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_EXTENTS" FOR "SYSCAT"."DBA_EXTENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_EXTENTS" FOR "SYSCAT"."USER_EXTENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_UNDO_EXTENTS" FOR "SYSCAT"."DBA_UNDO_EXTENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TRIGGERS" FOR "SYSCAT"."DBA_TRIGGERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TRIGGERS" FOR "SYSCAT"."USER_TRIGGERS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TRIGGERS" FOR "SYSCAT"."ALL_TRIGGERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PROCEDURES" FOR "SYSCAT"."DBA_PROCEDURES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PROCEDURES" FOR "SYSCAT"."USER_PROCEDURES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PROCEDURES" FOR "SYSCAT"."ALL_PROCEDURES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TYPES" FOR "SYSCAT"."DBA_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TYPES" FOR "SYSCAT"."USER_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TYPES" FOR "SYSCAT"."ALL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TYPE_METHODS" FOR "SYSCAT"."DBA_TYPE_METHODS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TYPE_METHODS" FOR "SYSCAT"."USER_TYPE_METHODS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TYPE_METHODS" FOR "SYSCAT"."ALL_TYPE_METHODS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TYPE_ATTRS" FOR "SYSCAT"."DBA_TYPE_ATTRS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TYPE_ATTRS" FOR "SYSCAT"."USER_TYPE_ATTRS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TYPE_ATTRS" FOR "SYSCAT"."ALL_TYPE_ATTRS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_COLL_TYPES" FOR "SYSCAT"."DBA_COLL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_COLL_TYPES" FOR "SYSCAT"."USER_COLL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_COLL_TYPES" FOR "SYSCAT"."ALL_COLL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_METHOD_PARAMS" FOR "SYSCAT"."DBA_METHOD_PARAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_METHOD_PARAMS" FOR "SYSCAT"."USER_METHOD_PARAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_METHOD_PARAMS" FOR "SYSCAT"."ALL_METHOD_PARAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_METHOD_RESULTS" FOR "SYSCAT"."DBA_METHOD_RESULTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_METHOD_RESULTS" FOR "SYSCAT"."USER_METHOD_RESULTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_METHOD_RESULTS" FOR "SYSCAT"."ALL_METHOD_RESULTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PACKAGE_TYPES" FOR "SYSCAT"."DBA_PACKAGE_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PACKAGE_TYPES" FOR "SYSCAT"."USER_PACKAGE_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PACKAGE_TYPES" FOR "SYSCAT"."ALL_PACKAGE_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PACKAGE_MEMBER" FOR "SYSCAT"."DBA_PACKAGE_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PACKAGE_MEMBER" FOR "SYSCAT"."USER_PACKAGE_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PACKAGE_MEMBER" FOR "SYSCAT"."ALL_PACKAGE_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PACKAGE_MEMBER_TYPES" FOR "SYSCAT"."DBA_PACKAGE_MEMBER_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PACKAGE_MEMBER_TYPES" FOR "SYSCAT"."USER_PACKAGE_MEMBER_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PACKAGE_MEMBER_TYPES" FOR "SYSCAT"."ALL_PACKAGE_MEMBER_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PACKAGE_COLL_TYPES" FOR "SYSCAT"."DBA_PACKAGE_COLL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PACKAGE_COLL_TYPES" FOR "SYSCAT"."USER_PACKAGE_COLL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_PACKAGE_COLL_TYPES" FOR "SYSCAT"."ALL_PACKAGE_COLL_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_ARGUMENTS" FOR "SYSCAT"."ALL_ARGUMENTS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_ARGUMENTS" FOR "SYSCAT"."USER_ARGUMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DATABASE_PROPERTIES" FOR "SYSCAT"."DATABASE_PROPERTIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JOBS" FOR "SYSCAT"."DBA_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JOBS" FOR "SYSCAT"."ALL_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JOBS" FOR "SYSCAT"."USER_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JOBS_WITH_NAME" FOR "SYSCAT"."DBA_JOBS_WITH_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JOBS_WITH_NAME" FOR "SYSCAT"."ALL_JOBS_WITH_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JOBS_WITH_NAME" FOR "SYSCAT"."USER_JOBS_WITH_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JOB_HISTORY" FOR "SYSCAT"."DBA_JOB_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JOB_HISTORY" FOR "SYSCAT"."ALL_JOB_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JOB_HISTORY" FOR "SYSCAT"."USER_JOB_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_OBJECTS" FOR "SYSCAT"."DBA_SCHEDULER_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_OBJECTS" FOR "SYSCAT"."ALL_SCHEDULER_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_OBJECTS" FOR "SYSCAT"."USER_SCHEDULER_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_JOBS" FOR "SYSCAT"."DBA_SCHEDULER_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_JOBS" FOR "SYSCAT"."ALL_SCHEDULER_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_JOBS" FOR "SYSCAT"."USER_SCHEDULER_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_PROGRAMS" FOR "SYSCAT"."DBA_SCHEDULER_PROGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_PROGRAMS" FOR "SYSCAT"."ALL_SCHEDULER_PROGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_PROGRAMS" FOR "SYSCAT"."USER_SCHEDULER_PROGRAMS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_CHAINS" FOR "SYSCAT"."DBA_SCHEDULER_CHAINS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_CHAINS" FOR "SYSCAT"."ALL_SCHEDULER_CHAINS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_CHAINS" FOR "SYSCAT"."USER_SCHEDULER_CHAINS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_RUNNING_JOBS" FOR "SYSCAT"."DBA_SCHEDULER_RUNNING_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_RUNNING_JOBS" FOR "SYSCAT"."ALL_SCHEDULER_RUNNING_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_RUNNING_JOBS" FOR "SYSCAT"."USER_SCHEDULER_RUNNING_JOBS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_STEPS" FOR "SYSCAT"."DBA_SCHEDULER_STEPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_STEPS" FOR "SYSCAT"."ALL_SCHEDULER_STEPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_STEPS" FOR "SYSCAT"."USER_SCHEDULER_STEPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_RULES" FOR "SYSCAT"."DBA_SCHEDULER_RULES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_RULES" FOR "SYSCAT"."ALL_SCHEDULER_RULES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_RULES" FOR "SYSCAT"."USER_SCHEDULER_RULES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_STEP_CTX" FOR "SYSCAT"."DBA_SCHEDULER_STEP_CTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_STEP_CTX" FOR "SYSCAT"."ALL_SCHEDULER_STEP_CTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_STEP_CTX" FOR "SYSCAT"."USER_SCHEDULER_STEP_CTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_RULE_CTX" FOR "SYSCAT"."DBA_SCHEDULER_RULE_CTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_RULE_CTX" FOR "SYSCAT"."ALL_SCHEDULER_RULE_CTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_RULE_CTX" FOR "SYSCAT"."USER_SCHEDULER_RULE_CTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_SCHEDULES" FOR "SYSCAT"."DBA_SCHEDULER_SCHEDULES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_SCHEDULES" FOR "SYSCAT"."ALL_SCHEDULER_SCHEDULES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_SCHEDULES" FOR "SYSCAT"."USER_SCHEDULER_SCHEDULES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_JOB_LOG" FOR "SYSCAT"."DBA_SCHEDULER_JOB_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_JOB_LOG" FOR "SYSCAT"."ALL_SCHEDULER_JOB_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_JOB_LOG" FOR "SYSCAT"."USER_SCHEDULER_JOB_LOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SCHEDULER_JOB_RUN_DETAILS" FOR "SYSCAT"."DBA_SCHEDULER_JOB_RUN_DETAILS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SCHEDULER_JOB_RUN_DETAILS" FOR "SYSCAT"."ALL_SCHEDULER_JOB_RUN_DETAILS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_SCHEDULER_JOB_RUN_DETAILS" FOR "SYSCAT"."USER_SCHEDULER_JOB_RUN_DETAILS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DIRECTORIES" FOR "SYSCAT"."DBA_DIRECTORIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_DIRECTORIES" FOR "SYSCAT"."ALL_DIRECTORIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_EXTERNAL_TABLES" FOR "SYSCAT"."DBA_EXTERNAL_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_EXTERNAL_TABLES" FOR "SYSCAT"."ALL_EXTERNAL_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_EXTERNAL_TABLES" FOR "SYSCAT"."USER_EXTERNAL_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_EXTERNAL_LOCATIONS" FOR "SYSCAT"."DBA_EXTERNAL_LOCATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_EXTERNAL_LOCATIONS" FOR "SYSCAT"."ALL_EXTERNAL_LOCATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_EXTERNAL_LOCATIONS" FOR "SYSCAT"."USER_EXTERNAL_LOCATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LIBRARIES" FOR "SYSCAT"."DBA_LIBRARIES"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_LIBRARIES" FOR "SYSCAT"."ALL_LIBRARIES"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_LIBRARIES" FOR "SYSCAT"."USER_LIBRARIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JAVA_CLASSES" FOR "SYSCAT"."DBA_JAVA_CLASSES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JAVA_CLASSES" FOR "SYSCAT"."ALL_JAVA_CLASSES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JAVA_CLASSES" FOR "SYSCAT"."USER_JAVA_CLASSES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JAVA_METHODS" FOR "SYSCAT"."DBA_JAVA_METHODS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JAVA_METHODS" FOR "SYSCAT"."ALL_JAVA_METHODS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JAVA_METHODS" FOR "SYSCAT"."USER_JAVA_METHODS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JAVA_FIELDS" FOR "SYSCAT"."DBA_JAVA_FIELDS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JAVA_FIELDS" FOR "SYSCAT"."ALL_JAVA_FIELDS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JAVA_FIELDS" FOR "SYSCAT"."USER_JAVA_FIELDS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_JAVA_ARGUMENTS" FOR "SYSCAT"."DBA_JAVA_ARGUMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_JAVA_ARGUMENTS" FOR "SYSCAT"."ALL_JAVA_ARGUMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_JAVA_ARGUMENTS" FOR "SYSCAT"."USER_JAVA_ARGUMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_OBJ_AUDIT_OPTS" FOR "SYSCAT"."DBA_OBJ_AUDIT_OPTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_OBJ_AUDIT_OPTS" FOR "SYSCAT"."USER_OBJ_AUDIT_OPTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PRIV_AUDIT_OPTS" FOR "SYSCAT"."DBA_PRIV_AUDIT_OPTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_AUDIT_TRAIL" FOR "SYSCAT"."DBA_AUDIT_TRAIL"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_AUDIT_TRAIL" FOR "SYSCAT"."USER_AUDIT_TRAIL"
/
CREATE OR REPLACE PUBLIC SYNONYM "SESSION_PRIVS" FOR "SYSCAT"."SESSION_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "ROLE_SYS_PRIVS" FOR "SYSCAT"."ROLE_SYS_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ROLE_TAB_PRIVS" FOR "SYSCAT"."ROLE_TAB_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ROLE_ROLE_PRIVS" FOR "SYSCAT"."ROLE_ROLE_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_REDEFINITION_OBJECTS" FOR "SYSCAT"."DBA_REDEFINITION_OBJECTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_STAT_EXTENSIONS" FOR "SYSCAT"."DBA_STAT_EXTENSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_STAT_EXTENSIONS" FOR "SYSCAT"."ALL_STAT_EXTENSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_STAT_EXTENSIONS" FOR "SYSCAT"."USER_STAT_EXTENSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_ENCRYPTED_COLUMNS" FOR "SYSCAT"."DBA_ENCRYPTED_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_ENCRYPTED_COLUMNS" FOR "SYSCAT"."ALL_ENCRYPTED_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_ENCRYPTED_COLUMNS" FOR "SYSCAT"."USER_ENCRYPTED_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_MVIEWS" FOR "SYSCAT"."DBA_MVIEWS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_MVIEWS" FOR "SYSCAT"."ALL_MVIEWS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_MVIEWS" FOR "SYSCAT"."USER_MVIEWS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_MVIEW_COLUMNS" FOR "SYSCAT"."USER_MVIEW_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_MVIEW_REFRESH_TIMES" FOR "SYSCAT"."DBA_MVIEW_REFRESH_TIMES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_MVIEW_REFRESH_TIMES" FOR "SYSCAT"."ALL_MVIEW_REFRESH_TIMES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_MVIEW_REFRESH_TIMES" FOR "SYSCAT"."USER_MVIEW_REFRESH_TIMES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_MVIEW_DETAIL_RELATIONS" FOR "SYSCAT"."DBA_MVIEW_DETAIL_RELATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_MVIEW_DETAIL_RELATIONS" FOR "SYSCAT"."ALL_MVIEW_DETAIL_RELATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_MVIEW_DETAIL_RELATIONS" FOR "SYSCAT"."USER_MVIEW_DETAIL_RELATIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_MVIEW_LOGS" FOR "SYSCAT"."DBA_MVIEW_LOGS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_MVIEW_LOGS" FOR "SYSCAT"."ALL_MVIEW_LOGS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_MVIEW_LOGS" FOR "SYSCAT"."USER_MVIEW_LOGS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TRIGGER_COLS" FOR "SYSCAT"."DBA_TRIGGER_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TRIGGER_COLS" FOR "SYSCAT"."ALL_TRIGGER_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TRIGGER_COLS" FOR "SYSCAT"."USER_TRIGGER_COLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_RECYCLEBIN" FOR "SYSCAT"."ALL_RECYCLEBIN"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_RECYCLEBIN" FOR "SYSCAT"."DBA_RECYCLEBIN"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_RECYCLEBIN" FOR "SYSCAT"."USER_RECYCLEBIN"
/
CREATE OR REPLACE PUBLIC SYNONYM "RECYCLEBIN" FOR "SYSCAT"."USER_RECYCLEBIN"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_QUEUE_SUBSCRIBERS" FOR "SYSCAT"."ALL_QUEUE_SUBSCRIBERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_QUEUE_SUBSCRIBERS" FOR "SYSCAT"."DBA_QUEUE_SUBSCRIBERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_QUEUE_SUBSCRIBERS" FOR "SYSCAT"."USER_QUEUE_SUBSCRIBERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_QUEUE_TABLES" FOR "SYSCAT"."ALL_QUEUE_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_QUEUE_TABLES" FOR "SYSCAT"."DBA_QUEUE_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_QUEUE_TABLES" FOR "SYSCAT"."USER_QUEUE_TABLES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_QUEUES" FOR "SYSCAT"."ALL_QUEUES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_QUEUES" FOR "SYSCAT"."DBA_QUEUES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_QUEUES" FOR "SYSCAT"."USER_QUEUES"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$OBJECT_USAGE" FOR "SYSCAT"."V$OBJECT_USAGE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PROFILES" FOR "SYSCAT"."DBA_PROFILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "SESSION_CONTEXT" FOR "SYSCAT"."SESSION_CONTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_POLICIES" FOR "SYSCAT"."DBA_POLICIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_POLICIES" FOR "SYSCAT"."ALL_POLICIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_POLICIES" FOR "SYSCAT"."USER_POLICIES"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TS_QUOTAS" FOR "SYSCAT"."DBA_TS_QUOTAS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TS_QUOTAS" FOR "SYSCAT"."USER_TS_QUOTAS"
/
CREATE OR REPLACE PUBLIC SYNONYM "PROXY_USERS" FOR "SYSCAT"."PROXY_USERS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_WORKSPACES" FOR "SYSCAT"."DBA_WORKSPACES"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_WORKSPACES" FOR "SYSCAT"."USER_WORKSPACES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_RSRC_PLANS" FOR "SYSCAT"."DBA_RSRC_PLANS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_RSRC_CONSUMER_GROUPS" FOR "SYSCAT"."DBA_RSRC_CONSUMER_GROUPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_RSRC_PLAN_DIRECTIVES" FOR "SYSCAT"."DBA_RSRC_PLAN_DIRECTIVES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_RSRC_AUDIT" FOR "SYSCAT"."DBA_RSRC_AUDIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SNAPSHOT" FOR "SYSCAT"."DBA_HIST_SNAPSHOT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SQLSTAT" FOR "SYSCAT"."DBA_HIST_SQLSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SQL_PLAN" FOR "SYSCAT"."DBA_HIST_SQL_PLAN"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SQLTEXT" FOR "SYSCAT"."DBA_HIST_SQLTEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SEG_STAT" FOR "SYSCAT"."DBA_HIST_SEG_STAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SYSTEM_EVENT" FOR "SYSCAT"."DBA_HIST_SYSTEM_EVENT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_WAITSTAT" FOR "SYSCAT"."DBA_HIST_WAITSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_LATCH" FOR "SYSCAT"."DBA_HIST_LATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SGASTAT" FOR "SYSCAT"."DBA_HIST_SGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_PGASTAT" FOR "SYSCAT"."DBA_HIST_PGASTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_LIBRARYCACHE" FOR "SYSCAT"."DBA_HIST_LIBRARYCACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_UNDOSTAT" FOR "SYSCAT"."DBA_HIST_UNDOSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_OSSTAT" FOR "SYSCAT"."DBA_HIST_OSSTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_PROCESS_MEM_SUMMARY" FOR "SYSCAT"."DBA_HIST_PROCESS_MEM_SUMMARY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_FILESTAT" FOR "SYSCAT"."DBA_HIST_FILESTAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SQL_WORKAREA_HSTGRM" FOR "SYSCAT"."DBA_HIST_SQL_WORKAREA_HSTGRM"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_ACTIVE_SESS_HISTORY" FOR "SYSCAT"."DBA_HIST_ACTIVE_SESS_HISTORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_AUDIT_POLICIES" FOR "SYSCAT"."DBA_AUDIT_POLICIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_FGA_AUDIT_TRAIL" FOR "SYSCAT"."DBA_FGA_AUDIT_TRAIL"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_TYPE_VERSIONS" FOR "SYSCAT"."ALL_TYPE_VERSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_TYPE_VERSIONS" FOR "SYSCAT"."USER_TYPE_VERSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_TYPE_VERSIONS" FOR "SYSCAT"."DBA_TYPE_VERSIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SYSMETRIC_SUMMARY" FOR "SYSCAT"."DBA_HIST_SYSMETRIC_SUMMARY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_HIST_SQLBIND" FOR "SYSCAT"."DBA_HIST_SQLBIND"
/
CREATE OR REPLACE PUBLIC SYNONYM "_ALL_SOURCE_FOR_TBEXPORT" FOR "SYSCAT"."_ALL_SOURCE_FOR_TBEXPORT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SQL_PROFILES" FOR "SYSCAT"."DBA_SQL_PROFILES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMSHSXP_SQL_PROFILE_ATTR" FOR "SYSCAT"."DBMSHSXP_SQL_PROFILE_ATTR"
/
CREATE OR REPLACE PUBLIC SYNONYM "CTX_PREFERENCES" FOR "SYSCAT"."CTX_PREFERENCES"
/
CREATE OR REPLACE PUBLIC SYNONYM "CTX_PREFERENCE_VALUES" FOR "SYSCAT"."CTX_PREFERENCE_VALUES"
/
CREATE OR REPLACE PUBLIC SYNONYM "CTX_STOPLISTS" FOR "SYSCAT"."CTX_STOPLISTS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_SQL_PLAN_BASELINES" FOR "SYSCAT"."DBA_SQL_PLAN_BASELINES"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LBAC_TABLE_POLICIES" FOR "SYSCAT"."DBA_LBAC_TABLE_POLICIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_LABELS" FOR "SYSCAT"."ALL_SA_LABELS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_POLICIES" FOR "SYSCAT"."ALL_SA_POLICIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_TABLE_POLICIES" FOR "SYSCAT"."ALL_SA_TABLE_POLICIES"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_LEVELS" FOR "SYSCAT"."ALL_SA_LEVELS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_COMPARTMENTS" FOR "SYSCAT"."ALL_SA_COMPARTMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_GROUPS" FOR "SYSCAT"."ALL_SA_GROUPS"/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_USER_LEVELS" FOR "SYSCAT"."ALL_SA_USER_LEVELS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_USER_COMPARTMENTS" FOR "SYSCAT"."ALL_SA_USER_COMPARTMENTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_SA_USER_GROUPS" FOR "SYSCAT"."ALL_SA_USER_GROUPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "V$IM_COLUMN_LEVEL" FOR "SYSCAT"."V$IM_COLUMN_LEVEL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PARALLEL_EXECUTE_TASKS" FOR "SYSCAT"."DBA_PARALLEL_EXECUTE_TASKS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PARALLEL_EXECUTE_TASKS" FOR "SYSCAT"."USER_PARALLEL_EXECUTE_TASKS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_PARALLEL_EXECUTE_CHUNKS" FOR "SYSCAT"."DBA_PARALLEL_EXECUTE_CHUNKS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_PARALLEL_EXECUTE_CHUNKS" FOR "SYSCAT"."USER_PARALLEL_EXECUTE_CHUNKS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DICTIONARY" FOR "SYSCAT"."DICTIONARY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DICT" FOR "SYSCAT"."DICTIONARY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DICTIONARY_COLUMNS" FOR "SYSCAT"."DICTIONARY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DICT_COLUMNS" FOR "SYSCAT"."DICTIONARY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DICT_COLS" FOR "SYSCAT"."DICTIONARY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_CATALOG" FOR "SYSCAT"."DBA_CATALOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_CATALOG" FOR "SYSCAT"."ALL_CATALOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_CATALOG" FOR "SYSCAT"."USER_CATALOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "TAB" FOR "SYSCAT"."TAB"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_COL_PRIVS" FOR "SYSCAT"."ALL_COL_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_COL_PRIVS" FOR "SYSCAT"."DBA_COL_PRIVS"/
CREATE OR REPLACE PUBLIC SYNONYM "USER_COL_PRIVS" FOR "SYSCAT"."USER_COL_PRIVS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_COL_PRIVS_MADE" FOR "SYSCAT"."ALL_COL_PRIVS_MADE"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_COL_PRIVS_MADE" FOR "SYSCAT"."USER_COL_PRIVS_MADE"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_COL_PRIVS_RECD" FOR "SYSCAT"."ALL_COL_PRIVS_RECD"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_COL_PRIVS_RECD" FOR "SYSCAT"."USER_COL_PRIVS_RECD"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_CONS_COLUMNS" FOR "SYSCAT"."DBA_CONS_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_CONS_COLUMNS" FOR "SYSCAT"."ALL_CONS_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_CONS_COLUMNS" FOR "SYSCAT"."USER_CONS_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_CONS_COLUMNS_INFO" FOR "SYSCAT"."ALL_CONS_COLUMNS_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LOG_GROUP_COLUMNS" FOR "SYSCAT"."DBA_LOG_GROUP_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_LOG_GROUP_COLUMNS" FOR "SYSCAT"."ALL_LOG_GROUP_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_LOG_GROUP_COLUMNS" FOR "SYSCAT"."USER_LOG_GROUP_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_CONSTRAINTS" FOR "SYSCAT"."DBA_CONSTRAINTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_CONSTRAINTS" FOR "SYSCAT"."ALL_CONSTRAINTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_CONSTRAINTS" FOR "SYSCAT"."USER_CONSTRAINTS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_LOG_GROUPS" FOR "SYSCAT"."DBA_LOG_GROUPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_LOG_GROUPS" FOR "SYSCAT"."ALL_LOG_GROUPS"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_ENCODE" FOR "SYS"."UTL_ENCODE"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_URL" FOR "SYS"."UTL_URL"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_HTTP" FOR "SYS"."UTL_HTTP"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_HTTP_INTERNAL" FOR "SYS"."UTL_HTTP_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_REPAIR" FOR "SYS"."DBMS_REPAIR"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SESSION" FOR "SYS"."DBMS_SESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_CRYPTO" FOR "SYS"."DBMS_CRYPTO"
/
CREATE OR REPLACE PUBLIC SYNONYM "PSM_SQL_RESULT_CACHE" FOR "SYS"."PSM_SQL_RESULT_CACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_TCP" FOR "SYS"."UTL_TCP"
/
CREATE OR REPLACE PUBLIC SYNONYM "HTP" FOR "SYS"."HTP"
/
CREATE OR REPLACE PUBLIC SYNONYM "HTF" FOR "SYS"."HTF"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_PIPE" FOR "SYS"."DBMS_PIPE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_RESULT_CACHE" FOR "SYS"."DBMS_RESULT_CACHE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_FLASHBACK" FOR "SYS"."DBMS_FLASHBACK"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SPH" FOR "SYS"."DBMS_SPH"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_EXPRESSION" FOR "SYS"."DBMS_EXPRESSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_RLS" FOR "SYS"."DBMS_RLS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_FGA" FOR "SYS"."DBMS_FGA"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_TYPES" FOR "SYS"."DBMS_TYPES"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICONST" FOR "SYS"."TUDICONST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICONST" FOR "SYS"."ODCICONST"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SQL_ANALYZE" FOR "SYS"."DBMS_SQL_ANALYZE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XMLGEN" FOR "SYS"."DBMS_XMLGEN"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XMLQUERY" FOR "SYS"."DBMS_XMLQUERY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_DEBUG" FOR "SYS"."DBMS_DEBUG"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_VERIFY" FOR "SYS"."DBMS_VERIFY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XMLDOM" FOR "SYS"."DBMS_XMLDOM"
/
CREATE OR REPLACE PUBLIC SYNONYM "XMLDOM" FOR "SYS"."DBMS_XMLDOM"
/
CREATE OR REPLACE PUBLIC SYNONYM "ANYDATA" FOR "SYS"."ANYDATA"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_RESOURCE_MANAGER" FOR "SYS"."DBMS_RESOURCE_MANAGER"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_DB_VERSION" FOR "SYS"."DBMS_DB_VERSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_SMTP" FOR "SYS"."UTL_SMTP"
/
CREATE OR REPLACE PUBLIC SYNONYM "DB2_STANDARD" FOR "SYS"."DB2_STANDARD"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_STANDARD" FOR "SYS"."DBMS_STANDARD"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_DDL" FOR "SYS"."DBMS_DDL"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_COMPRESS" FOR "SYS"."UTL_COMPRESS"
/
CREATE OR REPLACE PUBLIC SYNONYM "TEXT_JAPANESE_LEXER" FOR "SYS"."TEXT_JAPANESE_LEXER"
/
CREATE OR REPLACE PUBLIC SYNONYM "CTX_DDL" FOR "SYS"."CTX_DDL"
/
CREATE OR REPLACE PUBLIC SYNONYM "SEAF" FOR "SYS"."SEAF"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_ODCI" FOR "SYS"."DBMS_ODCI"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_REF" FOR "SYS"."UTL_REF"
/
CREATE OR REPLACE PUBLIC SYNONYM "OWA_UTIL" FOR "SYS"."OWA_UTIL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_ALERT" FOR "SYS"."DBMS_ALERT"
/
CREATE OR REPLACE PUBLIC SYNONYM "CLIENT_INTERNAL" FOR "SYS"."CLIENT_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "UDT_META_T" FOR "SYS"."UDT_META_T"
/
CREATE OR REPLACE PUBLIC SYNONYM "UDT_INFO_T" FOR "SYS"."UDT_INFO_T"
/
CREATE OR REPLACE PUBLIC SYNONYM "ATTR_META_T" FOR "SYS"."ATTR_META_T"
/
CREATE OR REPLACE PUBLIC SYNONYM "ATTR_IDX_ARR" FOR "SYS"."ATTR_IDX_ARR"
/
CREATE OR REPLACE PUBLIC SYNONYM "HIERARCHY_INFO_T" FOR "SYS"."HIERARCHY_INFO_T"
/
CREATE OR REPLACE PUBLIC SYNONYM "ATTR_META_ARR" FOR "SYS"."ATTR_META_ARR"
/
CREATE OR REPLACE PUBLIC SYNONYM "HIERARCHY_INFO_ARR" FOR "SYS"."HIERARCHY_INFO_ARR"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XSLPROCESSOR" FOR "SYS"."DBMS_XSLPROCESSOR"
/
CREATE OR REPLACE PUBLIC SYNONYM "OWA" FOR "SYS"."OWA"
/
CREATE OR REPLACE PUBLIC SYNONYM "VCTAB_OUTER" FOR "SYS"."VCTAB_OUTER"
/
CREATE OR REPLACE PUBLIC SYNONYM "NMTAB_OUTER" FOR "SYS"."NMTAB_OUTER"
/
CREATE OR REPLACE PUBLIC SYNONYM "RAWTAB_OUTER" FOR "SYS"."RAWTAB_OUTER"
/
CREATE OR REPLACE PUBLIC SYNONYM "OWA_SEC" FOR "SYS"."OWA_SEC"
/
CREATE OR REPLACE PUBLIC SYNONYM "OWA_CUSTOM" FOR "SYS"."OWA_CUSTOM"
/
CREATE OR REPLACE PUBLIC SYNONYM "OWA_INIT" FOR "SYS"."OWA_INIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "OWA_COOKIE" FOR "SYS"."OWA_COOKIE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_TPM" FOR "SYS"."DBMS_TPM"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SANITY" FOR "SYS"."DBMS_SANITY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XMLPARSER" FOR "SYS"."DBMS_XMLPARSER"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XMLSAVE" FOR "SYS"."DBMS_XMLSAVE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_XMLSCHEMA" FOR "SYS"."DBMS_XMLSCHEMA"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SPACE_SGMT_DROP" FOR "SYS"."DBMS_SPACE_SGMT_DROP"
/
CREATE OR REPLACE PUBLIC SYNONYM "CTX_OUTPUT" FOR "SYS"."CTX_OUTPUT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_PARALLEL_EXECUTE" FOR "SYS"."DBMS_PARALLEL_EXECUTE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_STATS" FOR "SYS"."DBMS_STATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_ERRLOG" FOR "SYS"."DBMS_ERRLOG"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_MVIEW" FOR "SYS"."DBMS_MVIEW"
/
CREATE OR REPLACE PUBLIC SYNONYM "TEXT" FOR "SYS"."TEXT"
/
CREATE OR REPLACE PUBLIC SYNONYM "TEXT_DDL" FOR "SYS"."TEXT_DDL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_METADATA" FOR "SYS"."DBMS_METADATA"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SCHEDULER_INTERNAL" FOR "SYS"."DBMS_SCHEDULER_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SCHEDULER_CHAIN_INTERNAL" FOR "SYS"."DBMS_SCHEDULER_CHAIN_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_ADDM" FOR "SYS"."DBMS_ADDM"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_TPM_INTERNAL" FOR "SYS"."DBMS_TPM_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "WM_CONCAT" FOR "SYS"."WM_CONCAT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_REDACT" FOR "SYS"."DBMS_REDACT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_REDACT_UTIL" FOR "SYS"."DBMS_REDACT_UTIL"
/
CREATE OR REPLACE PUBLIC SYNONYM "SA_USER_ADMIN" FOR "SYS"."SA_USER_ADMIN"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_TPR" FOR "SYS"."DBMS_TPR"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIINDEXINFO" FOR "SYS"."TUDIINDEXINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIPREDINFO" FOR "SYS"."TUDIPREDINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIRIDLIST" FOR "SYS"."TUDIRIDLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDINUMBERLIST" FOR "SYS"."TUDINUMBERLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIVARCHAR2LIST" FOR "SYS"."TUDIVARCHAR2LIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIDATELIST" FOR "SYS"."TUDIDATELIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIBFILELIST" FOR "SYS"."TUDIBFILELIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIRAWLIST" FOR "SYS"."TUDIRAWLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIINDEXCTX" FOR "SYS"."TUDIINDEXCTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOST" FOR "SYS"."TUDICOST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIARGDESC" FOR "SYS"."TUDIARGDESC"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIARGDESCLIST" FOR "SYS"."TUDIARGDESCLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIFUNCINFO" FOR "SYS"."TUDIFUNCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDISTATSOPTIONS" FOR "SYS"."TUDISTATSOPTIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOLINFO" FOR "SYS"."TUDICOLINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIFUNCCALLINFO" FOR "SYS"."TUDIFUNCCALLINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOLINFOLIST" FOR "SYS"."TUDICOLINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOLINFOLIST2" FOR "SYS"."TUDICOLINFOLIST2"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIOBJECT" FOR "SYS"."TUDIOBJECT"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIOBJECTLIST" FOR "SYS"."TUDIOBJECTLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIQUERYINFO" FOR "SYS"."TUDIQUERYINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIENV" FOR "SYS"."TUDIENV"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIPARTINFO" FOR "SYS"."TUDIPARTINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIEXTTABLEINFO" FOR "SYS"."TUDIEXTTABLEINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIEXTTABLEQCINFO" FOR "SYS"."TUDIEXTTABLEQCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIGRANULELIST" FOR "SYS"."TUDIGRANULELIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDITABFUNCINFO" FOR "SYS"."TUDITABFUNCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDITABFUNCSTATS" FOR "SYS"."TUDITABFUNCSTATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOLVALLIST" FOR "SYS"."TUDICOLVALLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOLARRAYVALLIST" FOR "SYS"."TUDICOLARRAYVALLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIPARTINFOLIST" FOR "SYS"."TUDIPARTINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIFILTERINFO" FOR "SYS"."TUDIFILTERINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIFILTERINFOLIST" FOR "SYS"."TUDIFILTERINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIORDERBYINFO" FOR "SYS"."TUDIORDERBYINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDIORDERBYINFOLIST" FOR "SYS"."TUDIORDERBYINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "TUDICOMPQUERYINFO" FOR "SYS"."TUDICOMPQUERYINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIINDEXINFO" FOR "SYS"."ODCIINDEXINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIPREDINFO" FOR "SYS"."ODCIPREDINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIRIDLIST" FOR "SYS"."ODCIRIDLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCINUMBERLIST" FOR "SYS"."ODCINUMBERLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIVARCHAR2LIST" FOR "SYS"."ODCIVARCHAR2LIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIDATELIST" FOR "SYS"."ODCIDATELIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIBFILELIST" FOR "SYS"."ODCIBFILELIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIRAWLIST" FOR "SYS"."ODCIRAWLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIINDEXCTX" FOR "SYS"."ODCIINDEXCTX"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOST" FOR "SYS"."ODCICOST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIARGDESC" FOR "SYS"."ODCIARGDESC"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIARGDESCLIST" FOR "SYS"."ODCIARGDESCLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIFUNCINFO" FOR "SYS"."ODCIFUNCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCISTATSOPTIONS" FOR "SYS"."ODCISTATSOPTIONS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOLINFO" FOR "SYS"."ODCICOLINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIFUNCCALLINFO" FOR "SYS"."ODCIFUNCCALLINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOLINFOLIST" FOR "SYS"."ODCICOLINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOLINFOLIST2" FOR "SYS"."ODCICOLINFOLIST2"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIOBJECT" FOR "SYS"."ODCIOBJECT"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIOBJECTLIST" FOR "SYS"."ODCIOBJECTLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIQUERYINFO" FOR "SYS"."ODCIQUERYINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIENV" FOR "SYS"."ODCIENV"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIPARTINFO" FOR "SYS"."ODCIPARTINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIEXTTABLEINFO" FOR "SYS"."ODCIEXTTABLEINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIEXTTABLEQCINFO" FOR "SYS"."ODCIEXTTABLEQCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIGRANULELIST" FOR "SYS"."ODCIGRANULELIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCITABFUNCINFO" FOR "SYS"."ODCITABFUNCINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCITABFUNCSTATS" FOR "SYS"."ODCITABFUNCSTATS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOLVALLIST" FOR "SYS"."ODCICOLVALLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOLARRAYVALLIST" FOR "SYS"."ODCICOLARRAYVALLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIPARTINFOLIST" FOR "SYS"."ODCIPARTINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIFILTERINFO" FOR "SYS"."ODCIFILTERINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIFILTERINFOLIST" FOR "SYS"."ODCIFILTERINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIORDERBYINFO" FOR "SYS"."ODCIORDERBYINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCIORDERBYINFOLIST" FOR "SYS"."ODCIORDERBYINFOLIST"
/
CREATE OR REPLACE PUBLIC SYNONYM "ODCICOMPQUERYINFO" FOR "SYS"."ODCICOMPQUERYINFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "UNITS_OF_MEASURE" FOR "SYSGIS"."UNITS_OF_MEASURE"
/
CREATE OR REPLACE PUBLIC SYNONYM "AREA_UNITS" FOR "SYSGIS"."AREA_UNITS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DIST_UNITS" FOR "SYSGIS"."DIST_UNITS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ANGLE_UNITS" FOR "SYSGIS"."ANGLE_UNITS"
/
CREATE OR REPLACE PUBLIC SYNONYM "SPATIAL_REF_SYS" FOR "SYSGIS"."SPATIAL_REF_SYS"
/
CREATE OR REPLACE PUBLIC SYNONYM "REGISTER_SRS" FOR "SYSGIS"."REGISTER_SPATIAL_REF_SYS"
/
CREATE OR REPLACE PUBLIC SYNONYM "UNREGISTER_SRS" FOR "SYSGIS"."UNREGISTER_SPATIAL_REF_SYS"
/
CREATE OR REPLACE PUBLIC SYNONYM "ALL_GEOMETRY_COLUMNS" FOR "SYSGIS"."ALL_GEOMETRY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "USER_GEOMETRY_COLUMNS" FOR "SYSGIS"."USER_GEOMETRY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "GEOMETRY_COLUMNS" FOR "SYSGIS"."USER_GEOMETRY_COLUMNS"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DML_LOCKS" FOR "SYSCAT"."DBA_DML_LOCKS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBA_DDL_LOCKS" FOR "SYSCAT"."DBA_DDL_LOCKS"/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_WM" FOR "SYS"."DBMS_WM"
/
CREATE OR REPLACE PUBLIC SYNONYM "STANDARD" FOR "SYS"."STANDARD"
/
CREATE OR REPLACE PUBLIC SYNONYM "STANDARD_EXTENSION" FOR "SYS"."STANDARD_EXTENSION"
/
CREATE OR REPLACE PUBLIC SYNONYM "STANDARD_EXTENSION_XML" FOR "SYS"."STANDARD_EXTENSION_XML"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_OUTPUT" FOR "SYS"."DBMS_OUTPUT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_LOB" FOR "SYS"."DBMS_LOB"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_MATCH" FOR "SYS"."UTL_MATCH"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_OBFUSCATION_TOOLKIT" FOR "SYS"."DBMS_OBFUSCATION_TOOLKIT"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_TRANSACTION" FOR "SYS"."DBMS_TRANSACTION"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SPACE_ADMIN" FOR "SYS"."DBMS_SPACE_ADMIN"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SPACE" FOR "SYS"."DBMS_SPACE"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_UTILITY" FOR "SYS"."DBMS_UTILITY"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_RANDOM" FOR "SYS"."DBMS_RANDOM"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_INMEMORY" FOR "SYS"."DBMS_INMEMORY"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_RAW" FOR "SYS"."UTL_RAW"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_I18N" FOR "SYS"."UTL_I18N"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_FILE" FOR "SYS"."UTL_FILE"
/
CREATE OR REPLACE PUBLIC SYNONYM "UTL_STR" FOR "SYS"."UTL_STR"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_LOCK" FOR "SYS"."DBMS_LOCK"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_JOB" FOR "SYS"."DBMS_JOB"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_JOB_WITH_NAME" FOR "SYS"."DBMS_JOB_WITH_NAME"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_JOB_WITH_NAME_INTERNAL" FOR "SYS"."DBMS_JOB_WITH_NAME_INTERNAL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SCHEDULER" FOR "SYS"."DBMS_SCHEDULER"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_SQL" FOR "SYS"."DBMS_SQL"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_ROWID" FOR "SYS"."DBMS_ROWID"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_APPLICATION_INFO" FOR "SYS"."DBMS_APPLICATION_INFO"
/
CREATE OR REPLACE PUBLIC SYNONYM "DBMS_JAVA" FOR "SYS"."DBMS_JAVA"
/
-- exporting schema:"SCOTT"
-- exporting tables
-- [2] SCOTT.DUMMY 1 rows exported.
-- [1] SCOTT.DEPT 4 rows exported.
-- [0] SCOTT.BONUS no rows exported.
-- [3] SCOTT.EMP 14 rows exported.
-- [2] SCOTT.SALGRADE 5 rows exported.
CREATE TABLE "BONUS" (
"ENAME" VARCHAR(10 BYTE),
"JOB" VARCHAR(9 BYTE),
"SAL" NUMBER,
"COMM" NUMBER
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
CREATE TABLE "DEPT" (
"DEPTNO" NUMBER(2),
"DNAME" VARCHAR(14 BYTE),
"LOC" VARCHAR(13 BYTE)
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
CREATE TABLE "DUMMY" (
"DUMMY" NUMBER
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
CREATE TABLE "EMP" (
"EMPNO" NUMBER(4),
"ENAME" VARCHAR(10 BYTE),
"JOB" VARCHAR(9 BYTE),
"MGR" NUMBER(4),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2)
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
CREATE TABLE "SALGRADE" (
"GRADE" NUMBER,
"LOSAL" NUMBER,
"HISAL" NUMBER
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
-- exporting constraints
ALTER TABLE "EMP" MODIFY "EMPNO" NOT NULL
/
-- exporting schema:"TIBERO"
-- exporting tables
-- [0] TIBERO.DEPT 4 rows exported.
-- [1] TIBERO.PRODUCT 1000001 rows exported.
CREATE TABLE "DEPT" (
"DEPTNO" NUMBER(2),
"DNAME" VARCHAR(14 BYTE),
"LOC" VARCHAR(13 BYTE)
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
CREATE TABLE "PRODUCT" (
"PROD_ID" NUMBER(6),
"PROD_NAME" VARCHAR(50 BYTE),
"PROD_COST" VARCHAR(30 BYTE),
"PROD_PID" NUMBER(6),
"PROD_DATE" DATE
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
/
-- exporting indexes
CREATE INDEX "TIBERO"."IDX_PRODUCT" ON "TIBERO"."PRODUCT" (
PROD_ID ASC
)
NOLOGGING
TABLESPACE "USR"
NOPARALLEL
PCTFREE 10
INITRANS 2
/
-- exporting schema:"TIBERO1"
-- Packing the file...
-- Export completed successfully : Tue Apr 11 15:32:09 KST 2023
[tibero@T1:/tibero/expimp]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> truncate table dept;
Table 'DEPT' truncated.
SQL> select * from dept;
0 row selected.
SQL> exit
Disconnected.
[tibero@T1:/tibero/expimp]$ tbimport IP=localhost PORT=8629 SID=tibero USERNAME=sys PASSWORD=tibero table=SCOTT.dept
tbimport 7.0
Copyright 2020 TmaxTibero Co., Ltd. All Rights Reserved.
Unpacking the file...
Import character set: MSWIN949
the TABLE: SCOTT.dept: Tue Apr 11 15:38:01 KST 2023
Import national character set: UTF-16
importing schema: "SCOTT"
importing table "DEPT"
[FAILED] TBR-7102: JDBC-7102:Duplicate schema object 'SCOTT.DEPT' exists. :
CREATE TABLE "DEPT" (
"DEPTNO" NUMBER(2),
"DNAME" VARCHAR(14 BYTE),
"LOC" VARCHAR(13 BYTE)
)
TABLESPACE "USR"
PCTFREE 10
INITRANS 2
STORAGE (
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOPARALLEL
Import completed with error: Tue Apr 11 15:38:01 KST 2023
[tibero@T1:/tibero/expimp]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> select * from dept;
0 row selected.
SQL> q
Disconnected.
[tibero@T1:/tibero/expimp]$ tbimport IP=localhost PORT=8629 SID=tibero USERNAME=sys PASSWORD=tibero table=SCOTT.dept ignore=y
tbimport 7.0
Copyright 2020 TmaxTibero Co., Ltd. All Rights Reserved.
Unpacking the file...
Import character set: MSWIN949
the TABLE: SCOTT.dept: Tue Apr 11 15:40:20 KST 2023
Import national character set: UTF-16
importing schema: "SCOTT"
importing table "DEPT"
[2] SCOTT.DEPT 4/4 rows imported.
Import completed successfully: Tue Apr 11 15:40:21 KST 2023
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
4 rows selected.
SQL>
SQL>
SQL> select count(*) from emp;
COUNT(*)
----------
14
1 row selected.
SQL> conn tibero/tmax
Connected to Tibero.
SQL> create table emp as select * from scott.emp;
Table 'EMP' created.
SQL> ls
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
IDX_PRODUCT INDEX
DEPT TABLE
EMP TABLE
PRODUCT TABLE
SQL> ls user
USERNAME
--------------------------------------------------------------------------------
TIBERO
SQL> ls table;
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
DEPT TABLE
EMP TABLE
PRODUCT TABLE
SQL> ls tablespace
TABLESPACE_NAME
--------------------------------------------------------------------------------
SYSTEM
UNDO
TEMP
USR
SYSSUB
MY_SPACE
SQL> help
HELP
----
Displays the Help.
{H[ELP]|?} topic
where topic is
! {exclamation} % {percent} @ {at} @@ {double at}
/ {slash} ACCEPT APPEND ARCHIVE LOG
CHANGE CLEAR COLUMN CONNECT
DEFINE DEL DESCRIBE DISCONNECT
EDIT EXECUTE EXIT EXPORT
HELP HISTORY HOST INPUT
LIST LOADFILE LOOP LS
PASSWORD PAUSE PING PRINT
PROMPT QUIT RESTORE RUN
SAVE SET SHOW TBDOWN
SPOOL START UNDEFINE VARIABLE
WHENEVER
SQL> exit
Disconnected.
[tibero@T1:/tibero/expimp]$ ls
default.dat ExpImp_23_04_11_153800.log tbExport.log
ExpImp_23_04_11_153203.log ExpImp_23_04_11_154020.log tbImport.log
[tibero@T1:/tibero/expimp]$ cd ..
[tibero@T1:/tibero]$ mkdir load
[tibero@T1:/tibero]$ cd load/
[tibero@T1:/tibero/load]$ ls
[tibero@T1:/tibero/load]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> export query 'emp.scv'
Ready to export to 'emp.scv'
SQL> select * from emp;
14 rows exported.
SQL> q
Disconnected.
[tibero@T1:/tibero/load]$ ls
emp.ctl emp.scv
[tibero@T1:/tibero/load]$ cat emp.scv
"7369","SMITH","CLERK","7902","2023/04/11","800","","20"
"7499","ALLEN","SALESMAN","7698","2023/04/11","1600","300","30"
"7521","WARD","SALESMAN","7698","2023/04/11","1250","500","30"
"7566","JONES","MANAGER","7839","2023/04/11","2975","","20"
"7654","MARTIN","SALESMAN","7698","2023/04/11","1250","1400","30"
"7698","BLAKE","MANAGER","7839","2023/04/11","2850","","30"
"7782","CLARK","MANAGER","7839","2023/04/11","2450","","10"
"7788","SCOTT","ANALYST","7566","2023/04/11","3000","","20"
"7839","KING","PRESIDENT","","2023/04/11","5000","","10"
"7844","TURNER","SALESMAN","7698","2023/04/11","1500","0","30"
"7876","ADAMS","CLERK","7788","2023/04/11","1100","","20"
"7900","JAMES","CLERK","7698","2023/04/11","950","","30"
"7902","FORD","ANALYST","7566","2023/04/11","3000","","20"
"7934","MILLER","CLERK","7782","2023/04/11","1300","","10"
[tibero@T1:/tibero/load]$ cat emp.ctl
LOAD DATA
INFILE 'emp.scv'
INTO TABLE emp
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(
"EMPNO" CHAR,
"ENAME" CHAR,
"JOB" CHAR,
"MGR" CHAR,
"HIREDATE" DATE "YYYY/MM/DD",
"SAL" CHAR,
"COMM" CHAR,
"DEPTNO" CHAR
)
[tibero@T1:/tibero/load]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> truncate table emp
2 ;
Table 'EMP' truncated.
SQL> select * from emp;
0 row selected.
SQL> q
Disconnected.
[tibero@T1:/tibero/load]$ which tbloader
/tibero/tibero7/client/bin/tbloader
[tibero@T1:/tibero/load]$ tbloader
tbLoader 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Usage : tbloader [options] [controls]
Options:
-h|--help Display the more detailed information.
-c|--charset Display usable character sets in this version.
-v|--version Display the version information.
Controls:
userid Username/password@dbname
control The name of the control file
data The name of the data file
log The name of the log file
bad The name of the bad file
discard The name of the discard file
skip The count of line to skip in data file (Default: 0)
errors The count of error to allow (Default: 50)
rows The count of row for each commit
(Default: commit after the end)
message The count of records to process to print out (Default: 0)
readsize The size of buffer to read from the data file
(Default: 65536)
disable_idx Whether to disable indexes before loading (Default: N)
direct Whether to use the Direct Path Loading (Default: N)
dpl_log Whether to log about the Direct Path Loading (Default: N)
parallel The count of threads to execute Parallel Direct Path Loading
(Default: 1)
bindsize The size of buffer to read in the Direct Path Loading
(Default: 65536)
syntax Control file syntax (Default : tibero)
dpl_parallel Deprecated
multithread Deprecated
Example:
tbloader userid=userid/passwd@dbname control=sample.ctl bindsize=1000000
[tibero@T1:/tibero/load]$ tbloader userid=scott/tiger@tibero control=emp.ctl
tbLoader 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Start loading...
Committed and Completed successfully.
[tibero@T1:/tibero/load]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> select * from emp;
EMPNO ENAME JOB MGR
---------- ---------- --------- ----------
HIREDATE
--------------------------------------------------------------------------------
SAL COMM DEPTNO
---------- ---------- ----------
7369 SMITH CLERK 7902
2023/04/11
800 20
7499 ALLEN SALESMAN 7698
2023/04/11
1600 300 30
7521 WARD SALESMAN 7698
2023/04/11
1250 500 30
7566 JONES MANAGER 7839
2023/04/11
2975 20
7654 MARTIN SALESMAN 7698
2023/04/11
1250 1400 30
EMPNO ENAME JOB MGR
---------- ---------- --------- ----------
HIREDATE
--------------------------------------------------------------------------------
SAL COMM DEPTNO
---------- ---------- ----------
7698 BLAKE MANAGER 7839
2023/04/11
2850 30
7782 CLARK MANAGER 7839
2023/04/11
2450 10
7788 SCOTT ANALYST 7566
2023/04/11
3000 20
7839 KING PRESIDENT
2023/04/11
5000 10
7844 TURNER SALESMAN 7698
2023/04/11
1500 0 30
EMPNO ENAME JOB MGR
---------- ---------- --------- ----------
HIREDATE
--------------------------------------------------------------------------------
SAL COMM DEPTNO
---------- ---------- ----------
7876 ADAMS CLERK 7788
2023/04/11
1100 20
7900 JAMES CLERK 7698
2023/04/11
950 30
7902 FORD ANALYST 7566
2023/04/11
3000 20
7934 MILLER CLERK 7782
2023/04/11
1300 10
14 rows selected.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> q
Disconnected.
[tibero@T1:/tibero/load]$ ls
emp.ctl emp.log emp.scv
[tibero@T1:/tibero/load]$ cat emp.log
tbLoader 7
Data File : emp.scv
Bad File : emp.bad
Discard File : emp.dsc
Table SCOTT.EMP, was loaded from the data file.
COLUMN_NAME POSITION DATATYPE
------------------------------ ---------- ----------------
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
EMPNO 1 CHARACTER
ENAME 2 CHARACTER
JOB 3 CHARACTER
MGR 4 CHARACTER
HIREDATE 5 DATE
SAL 6 CHARACTER
COMM 7 CHARACTER
DEPTNO 8 CHARACTER
Table SCOTT.EMP :
0 Rows were skipped.
14 Rows were requested to load.
14 Rows were loaded successfully.
0 Rows were failed to load because of some errors
0 Rows were discarded.
Total Elapsed Time : 00:00:00.153371
[tibero@T1:/tibero/load]$ ls
emp.ctl emp.log emp.scv
[tibero@T1:/tibero/load]$ ls -l
total 12
-rw-r--r-- 1 tibero dba 252 Apr 11 16:29 emp.ctl
-rw-r--r-- 1 tibero dba 1006 Apr 11 16:35 emp.log
-rw-r--r-- 1 tibero dba 843 Apr 11 16:29 emp.scv
[tibero@T1:/tibero/load]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> truncate table emp;
Table 'EMP' truncated.
SQL> ls
NAME SUBNAME TYPE
---------------------------------- ------------------------ --------------------
BONUS TABLE
DEPT TABLE
DUMMY TABLE
EMP TABLE
SALGRADE TABLE
SQL> select * from emp;
0 row selected.
SQL> q
Disconnected.
[tibero@T1:/tibero]$ mkdir load2
[tibero@T1:/tibero]$ cd load2
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ vi example.ctl
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ vi example.dat
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ ls -l
total 8
-rw-r--r-- 1 tibero dba 357 Apr 11 16:41 example.ctl
-rw-r--r-- 1 tibero dba 326 Apr 11 16:42 example.dat
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ tbloader userid=scott/tiger@tibero control=example.ctl
tbLoader 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Start loading...
TBR-80032: Invalid enclosed string was used.
Committed and Completed successfully.
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ ls -l
total 16
-rw-r--r-- 1 tibero dba 108 Apr 11 16:43 example.bad
-rw-r--r-- 1 tibero dba 357 Apr 11 16:41 example.ctl
-rw-r--r-- 1 tibero dba 326 Apr 11 16:42 example.dat
-rw-r--r-- 1 tibero dba 1124 Apr 11 16:43 example.log
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ cat example.dat
7654, "Martin", "Sales",7698,1981/10/28,1312.50,3,10
7782, "\,Clark","Manager" ,7839, 1981/01/11 ,2572.50,10,20
7839, "King",President,,1981/11/17,5500.00,,10
7934,"Miller","Clerk",7782 ,1977/10/12,920.00,,10
7566, "Jones",Manager" ,7839, 1981/04/02,3123.75,,20
7658, "Chan", Ana lyst, 7566,1982/05/03,3450,,20
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ cat example.bad
7566, "Jones",Manager" ,7839, 1981/04/02,3123.75,,20
7658, "Chan", Ana lyst, 7566,1982/05/03,3450,,20
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> SELECT COUNT(*) FROM EMP;
COUNT(*)
----------
4
1 row selected.
SQL> q
Disconnected.
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ ls -l
total 16
-rw-r--r-- 1 tibero dba 108 Apr 11 16:43 example.bad
-rw-r--r-- 1 tibero dba 357 Apr 11 16:41 example.ctl
-rw-r--r-- 1 tibero dba 326 Apr 11 16:42 example.dat
-rw-r--r-- 1 tibero dba 1124 Apr 11 16:43 example.log
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ cat example.log
tbLoader 7
Data File : example.dat
Bad File : example.bad
Discard File : example.dsc
Table SCOTT.EMP, was loaded from the data file.
COLUMN_NAME POSITION DATATYPE
------------------------------ ---------- ----------------
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
EMPNO 1 CHARACTER
ENAME 2 CHARACTER
JOB 3 CHARACTER
MGR 4 CHARACTER
HIREDATE 5 DATE
SAL 6 CHARACTER
COMM 7 CHARACTER
DEPTNO 8 CHARACTER
Record 5 was rejected.
Error at Table 'EMP', Column 'JOB':
TBR-80032: Invalid enclosed string was used.
Table SCOTT.EMP :
0 Rows were skipped.
5 Rows were requested to load.
4 Rows were loaded successfully.
1 Rows were failed to load because of some errors
0 Rows were discarded.
Total Elapsed Time : 00:00:00.019502
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ ls -l
total 16
-rw-r--r-- 1 tibero dba 108 Apr 11 16:43 example.bad
-rw-r--r-- 1 tibero dba 357 Apr 11 16:41 example.ctl
-rw-r--r-- 1 tibero dba 326 Apr 11 16:42 example.dat
-rw-r--r-- 1 tibero dba 1124 Apr 11 16:43 example.log
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ vi example.bad
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ cp example.dat example.dat_01
[tibero@T1:/tibero/load2]$ cp example.bad example.dat
[tibero@T1:/tibero/load2]$ cat example.dat
7566, "Jones","Manager" ,7839, 1981/04/02,3123.75,,20
7658, "Chan", Ana lyst, 7566,1982/05/03,3450,,20
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ tbloader userid=scott/tiger@tibero control=example.ctl
tbLoader 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Start loading...
Committed and Completed successfully.
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$
[tibero@T1:/tibero/load2]$ tbsql scott/tiger
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Connected to Tibero.
SQL> SELECT COUNT(*) FROM EMP;
COUNT(*)
----------
6
1 row selected.
SQL> SELECT * FROM EMP;
EMPNO ENAME JOB MGR
---------- ---------- --------- ----------
HIREDATE
--------------------------------------------------------------------------------
SAL COMM DEPTNO
---------- ---------- ----------
7654 Martin Sales 7698
1981/10/28
1312.5 3 10
7782 ,Clark Manager 7839
1981/01/11
2572.5 10 20
7839 King President
1981/11/17
5500 10
7934 Miller Clerk 7782
1977/10/12
920 10
7566 Jones Manager 7839
1981/04/02
3123.75 20
EMPNO ENAME JOB MGR
---------- ---------- --------- ----------
HIREDATE
--------------------------------------------------------------------------------
SAL COMM DEPTNO
---------- ---------- ----------
7658 Chan Ana lyst 7566
1982/05/03
3450 20
6 rows selected.
SQL> SELECT ENAME, DEPTNO FROM EMP;
ENAME DEPTNO
---------- ----------
Martin 10
,Clark 20
King 10
Miller 10
Jones 20
Chan 20
6 rows selected.
SQL> SELECT ENAME, JOB FROM EMP;
ENAME JOB
---------- ---------
Martin Sales
,Clark Manager
King President
Miller Clerk
Jones Manager
Chan Ana lyst
6 rows selected.
SQL>
