1 contributor
use strict;
use warnings;
use FindBin;
$ENV{DBIX_CUSTOM_TEST_RUN} = 1
if -f "$FindBin::Bin/run/common-oracle.run";
$ENV{DBIX_CUSTOM_SKIP_MESSAGE} = 'oracle private test';
use DBIx::Custom;
{
package DBIx::Custom;
no warnings 'redefine';
has dbi_option => sub {
{
Callbacks => {
connected => sub {
shift->do(
"ALTER SESSION SET NLS_DATE_FORMAT = 'RR-MM-DD HH24:MI:SS'"
);
return;
},
}
}
};
my $table1 = 'TABLE1';
my $table2 = 'TABLE2';
my $table2_alias = 'TABLE2_ALIAS';
my $table3 = 'TABLE3';
my $key1 = 'KEY1';
my $key2 = 'KEY2';
my $key3 = 'KEY3';
my $key4 = 'KEY4';
my $key5 = 'KEY5';
my $key6 = 'KEY6';
my $key7 = 'KEY7';
my $key8 = 'KEY8';
my $key9 = 'KEY9';
my $key10 = 'KEY10';
has table1 => $table1;
has table2 => $table2;
has table2_alias => $table2_alias;
has table3 => $table3;
has key1 => $key1;
has key2 => $key2;
has key3 => $key3;
has key4 => $key4;
has key5 => $key5;
has key6 => $key6;
has key7 => $key7;
has key8 => $key8;
has key9 => $key9;
has key10 => $key10;
my $date_typename = 'CHAR(10)';
my $datetime_typename = 'DATE';
sub date_typename { lc 'CHAR' }
sub datetime_typename { lc $datetime_typename }
my $date_datatype = 1;
my $datetime_datatype = 93;
sub date_datatype { lc $date_datatype }
sub datetime_datatype { lc $datetime_datatype }
my @system_tables = qw#
WWV_FLOW_SESSION_SEQ
WWV_SEQ
SAMPLE_SEQ
SDO_IDX_TAB_SEQUENCE
TMP_COORD_OPS
XDB$NAMESUFF_SEQ
ABSPATH
ALERT_TYPE
ALL_
ANYDATA
ANYDATASET
ANYTYPE
APEX
APPLICATION_AUTHENTICATION
AQ$INTERNET_USERS
AREA
ASBINARY
ASTEXT
AUDIT_ACTIONS
AWRDRPT_TEXT_TYPE
AWRRPT_CLB_ARY
AWRRPT_HTML_TYPE
AWRRPT_NUM_ARY
AWRRPT_ROW_TYPE
AWRRPT_TEXT_TYPE
AWRRPT_VCH_ARY
AWRSQRPT_TEXT_TYPE
BOUNDARY
BUFFER
CAT
CATSEARCH
CENTROID
CHANGE_PROPAGATIONS
CHANGE_PROPAGATION_SETS
CHANGE_SETS
CHANGE_SOURCES
CIRCULARSTRING
CLU
COL
COLLECT
COLS
COLUMN_PRIVILEGES
COMPOUNDCURVE
CONTAINS
CONTENTSCHEMAIS
CONTEXT
CONVEXHULL
CROSS
CS_SRS
CTXCAT
CTXRULE
CTXXPATH
CTX_CLASSES
CTX_CLS
CTX_DDL
CTX_DOC
CTX_INDEX_SETS
CTX_INDEX_SET_INDEXES
CTX_OBJECTS
CTX_OBJECT_ATTRIBUTES
CTX_OBJECT_ATTRIBUTE_LOV
CTX_OUTPUT
CTX_PARAMETERS
CTX_PREFERENCES
CTX_PREFERENCE_VALUES
CTX_QUERY
CTX_REPORT
CTX_SECTIONS
CTX_SECTION_GROUPS
CTX_SQES
CTX_STOPLISTS
CTX_STOPWORDS
CTX_SUB_LEXERS
CTX_THES
CTX_THESAURI
CTX_THES_PHRASES
CTX_TRACE_VALUES
CTX_ULEXER
CTX_USER_INDEXES
CTX_USER_INDEX_ERRORS
CTX_USER_INDEX_OBJECTS
CTX_USER_INDEX_PARTITIONS
CTX_USER_INDEX_SETS
CTX_USER_INDEX_SET_INDEXES
CTX_USER_INDEX_SUB_LEXERS
CTX_USER_INDEX_SUB_LEXER_VALS
CTX_USER_INDEX_VALUES
CTX_USER_PENDING
CTX_USER_PREFERENCES
CTX_USER_PREFERENCE_VALUES
CTX_USER_SECTIONS
CTX_USER_SECTION_GROUPS
CTX_USER_SQES
CTX_USER_STOPLISTS
CTX_USER_STOPWORDS
CTX_USER_SUB_LEXERS
CTX_USER_THESAURI
CTX_USER_THES_PHRASES
CURVE
CURVEPOLYGON
DATABASE_COMPATIBLE_LEVEL
DATABASE_EXPORT_OBJECTS
DATABASE_PROPERTIES
DATAPUMP_OBJECT_CONNECT
DATAPUMP_PATHMAP
DATAPUMP_PATHS
DATAPUMP_REMAP_OBJECTS
DBA_2PC_NEIGHBORS
DBA_
DBMSHSXP
DBMSHSXP_SQL_PROFILE_ATTR
DBMSOBJGWRAPPER
DBMSOUTPUT_LINESARRAY
DBMSZEXP_SYSPKGGRNT
DBMS_
DBURITYPE
DEFCALL
DEFCALLDEST
DEFDEFAULTDEST
DEFERRCOUNT
DEFERROR
DEFLOB
DEFPROPAGATOR
DEFSCHEDULE
DEFTRAN
DEFTRANDEST
DEPTH
DEVELOPMENT_SERVICE_HOME
DEVELOPMENT_SERVICE_HOME_LOGIN
DEVELOPMENT_SERVICE_SIGNUP
DICT
DICTIONARY
DICT_COLUMNS
DIFFERENCE
DIMENSION
DISJOINT
DISTANCE
DM_CENTROIDS
DM_CL_BUILD
DM_SVM_APPLY
DM_SVM_BUILD
DRVODM
DS_SQL_WORKSHOP
DUAL
ENDPOINT
ENVELOPE
EQUALS
EQUALS_PATH
EXPLAINMVARRAYTYPE
EXPLAINMVMESSAGE
EXTERIORRING
F
FLASHBACK_TRANSACTION_QUERY
FTPURITYPE
GEOMETRY
GEOMETRYCOLLECTION
GEOMETRYN
GEOMETRYTYPE
GLOBAL_CONTEXT
GLOBAL_NAME
GV$ACCESS
GV$ACTIVE_INSTANCES
GV$ACTIVE_SERVICES
GV$ACTIVE_SESSION_HISTORY
GV$ACTIVE_SESS_POOL_MTH
GV$ADVISOR_PROGRESS
GV$ALERT_TYPES
GV$AQ
GV$AQ1
GV$ARCHIVE
GV$ARCHIVED_LOG
GV$ARCHIVE_DEST
GV$ARCHIVE_DEST_STATUS
GV$ARCHIVE_GAP
GV$ARCHIVE_PROCESSES
GV$ASM_ALIAS
GV$ASM_CLIENT
GV$ASM_DISK
GV$ASM_DISKGROUP
GV$ASM_DISKGROUP_STAT
GV$ASM_DISK_STAT
GV$ASM_FILE
GV$ASM_OPERATION
GV$ASM_TEMPLATE
GV$AW_AGGREGATE_OP
GV$AW_ALLOCATE_OP
GV$AW_CALC
GV$AW_LONGOPS
GV$AW_OLAP
GV$AW_SESSION_INFO
GV$BACKUP
GV$BACKUP_ASYNC_IO
GV$BACKUP_CORRUPTION
GV$BACKUP_DATAFILE
GV$BACKUP_DEVICE
GV$BACKUP_PIECE
GV$BACKUP_REDOLOG
GV$BACKUP_SET
GV$BACKUP_SPFILE
GV$BACKUP_SYNC_IO
GV$BGPROCESS
GV$BH
GV$BLOCKING_QUIESCE
GV$BSP
GV$BUFFERED_PUBLISHERS
GV$BUFFERED_QUEUES
GV$BUFFERED_SUBSCRIBERS
GV$BUFFER_POOL
GV$BUFFER_POOL_STATISTICS
GV$CIRCUIT
GV$CLASS_CACHE_TRANSFER
GV$CLASS_PING
GV$CLIENT_STATS
GV$CLUSTER_INTERCONNECTS
GV$CONFIGURED_INTERCONNECTS
GV$CONTEXT
GV$CONTROLFILE
GV$CONTROLFILE_RECORD_SECTION
GV$COPY_CORRUPTION
GV$CR_BLOCK_SERVER
GV$CURRENT_BLOCK_SERVER
GV$DATABASE
GV$DATABASE_BLOCK_CORRUPTION
GV$DATABASE_INCARNATION
GV$DATAFILE
GV$DATAFILE_COPY
GV$DATAFILE_HEADER
GV$DATAGUARD_CONFIG
GV$DATAGUARD_STATUS
GV$DATAPUMP_JOB
GV$DATAPUMP_SESSION
GV$DBFILE
GV$DBLINK
GV$DB_CACHE_ADVICE
GV$DB_OBJECT_CACHE
GV$DB_PIPES
GV$DELETED_OBJECT
GV$DISPATCHER
GV$DISPATCHER_CONFIG
GV$DISPATCHER_RATE
GV$DLM_ALL_LOCKS
GV$DLM_CONVERT_LOCAL
GV$DLM_CONVERT_REMOTE
GV$DLM_LATCH
GV$DLM_LOCKS
GV$DLM_MISC
GV$DLM_RESS
GV$DLM_TRAFFIC_CONTROLLER
GV$ENABLEDPRIVS
GV$ENQUEUE_LOCK
GV$ENQUEUE_STAT
GV$ENQUEUE_STATISTICS
GV$EVENTMETRIC
GV$EVENT_HISTOGRAM
GV$EVENT_NAME
GV$EXECUTION
GV$FAST_START_SERVERS
GV$FAST_START_TRANSACTIONS
GV$FILEMETRIC
GV$FILEMETRIC_HISTORY
GV$FILESPACE_USAGE
GV$FILESTAT
GV$FILE_CACHE_TRANSFER
GV$FILE_HISTOGRAM
GV$FILE_PING
GV$FIXED_VIEW_DEFINITION
GV$FLASHBACK_DATABASE_LOG
GV$FLASHBACK_DATABASE_LOGFILE
GV$FLASHBACK_DATABASE_STAT
GV$GCSHVMASTER_INFO
GV$GCSPFMASTER_INFO
GV$GC_ELEMENT
GV$GC_ELEMENTS_WITH_COLLISIONS
GV$GES_BLOCKING_ENQUEUE
GV$GES_ENQUEUE
GV$GLOBALCONTEXT
GV$GLOBAL_BLOCKED_LOCKS
GV$GLOBAL_TRANSACTION
GV$HS_AGENT
GV$HS_PARAMETER
GV$HS_SESSION
GV$HVMASTER_INFO
GV$INDEXED_FIXED_COLUMN
GV$INSTANCE
GV$INSTANCE_CACHE_TRANSFER
GV$INSTANCE_LOG_GROUP
GV$INSTANCE_RECOVERY
GV$JAVAPOOL
GV$JAVA_LIBRARY_CACHE_MEMORY
GV$JAVA_POOL_ADVICE
GV$LATCH
GV$LATCHHOLDER
GV$LATCHNAME
GV$LATCH_CHILDREN
GV$LATCH_MISSES
GV$LATCH_PARENT
GV$LIBRARYCACHE
GV$LIBRARY_CACHE_MEMORY
GV$LICENSE
GV$LOADISTAT
GV$LOADPSTAT
GV$LOCK
GV$LOCKED_OBJECT
GV$LOCKS_WITH_COLLISIONS
GV$LOCK_ACTIVITY
GV$LOCK_ELEMENT
GV$LOCK_TYPE
GV$LOG
GV$LOGFILE
GV$LOGHIST
GV$LOGMNR_CALLBACK
GV$LOGMNR_CONTENTS
GV$LOGMNR_DICTIONARY
GV$LOGMNR_DICTIONARY_LOAD
GV$LOGMNR_LATCH
GV$LOGMNR_LOGFILE
GV$LOGMNR_LOGS
GV$LOGMNR_PARAMETERS
GV$LOGMNR_PROCESS
GV$LOGMNR_REGION
GV$LOGMNR_SESSION
GV$LOGMNR_STATS
GV$LOGMNR_TRANSACTION
GV$LOGSTDBY
GV$LOGSTDBY_PROCESS
GV$LOGSTDBY_PROGRESS
GV$LOGSTDBY_STATE
GV$LOGSTDBY_STATS
GV$LOGSTDBY_TRANSACTION
GV$LOG_HISTORY
GV$MANAGED_STANDBY
GV$MAP_COMP_LIST
GV$MAP_ELEMENT
GV$MAP_EXT_ELEMENT
GV$MAP_FILE
GV$MAP_FILE_EXTENT
GV$MAP_FILE_IO_STACK
GV$MAP_LIBRARY
GV$MAP_SUBELEMENT
GV$MAX_ACTIVE_SESS_TARGET_MTH
GV$METRIC
GV$METRICGROUP
GV$METRICNAME
GV$METRIC_HISTORY
GV$MTTR_TARGET_ADVICE
GV$MUTEX_SLEEP
GV$MUTEX_SLEEP_HISTORY
GV$MVREFRESH
GV$MYSTAT
GV$NLS_PARAMETERS
GV$NLS_VALID_VALUES
GV$OBJECT_DEPENDENCY
GV$OBSOLETE_PARAMETER
GV$OFFLINE_RANGE
GV$OPEN_CURSOR
GV$OPTION
GV$OSSTAT
GV$PARALLEL_DEGREE_LIMIT_MTH
GV$PARAMETER
GV$PARAMETER2
GV$PARAMETER_VALID_VALUES
GV$PGASTAT
GV$PGA_TARGET_ADVICE
GV$PGA_TARGET_ADVICE_HISTOGRAM
GV$PQ_SESSTAT
GV$PQ_SLAVE
GV$PQ_SYSSTAT
GV$PQ_TQSTAT
GV$PROCESS
GV$PROCESS_MEMORY
GV$PROCESS_MEMORY_DETAIL
GV$PROCESS_MEMORY_DETAIL_PROG
GV$PROPAGATION_RECEIVER
GV$PROPAGATION_SENDER
GV$PROXY_ARCHIVEDLOG
GV$PROXY_DATAFILE
GV$PWFILE_USERS
GV$PX_BUFFER_ADVICE
GV$PX_PROCESS
GV$PX_PROCESS_SYSSTAT
GV$PX_SESSION
GV$PX_SESSTAT
GV$QUEUE
GV$QUEUEING_MTH
GV$RECOVERY_FILE_STATUS
GV$RECOVERY_LOG
GV$RECOVERY_PROGRESS
GV$RECOVERY_STATUS
GV$RECOVER_FILE
GV$REPLPROP
GV$REPLQUEUE
GV$REQDIST
GV$RESERVED_WORDS
GV$RESOURCE
GV$RESOURCE_LIMIT
GV$RESTORE_POINT
GV$RESUMABLE
GV$RFS_THREAD
GV$RMAN_CONFIGURATION
GV$RMAN_OUTPUT
GV$ROLLSTAT
GV$ROWCACHE
GV$ROWCACHE_PARENT
GV$ROWCACHE_SUBORDINATE
GV$RSRC_CONSUMER_GROUP
GV$RSRC_CONSUMER_GROUP_CPU_MTH
GV$RSRC_CONS_GROUP_HISTORY
GV$RSRC_PLAN
GV$RSRC_PLAN_CPU_MTH
GV$RSRC_PLAN_HISTORY
GV$RSRC_SESSION_INFO
GV$RULE
GV$RULE_SET
GV$RULE_SET_AGGREGATE_STATS
GV$SCHEDULER_RUNNING_JOBS
GV$SEGMENT_STATISTICS
GV$SEGSTAT
GV$SEGSTAT_NAME
GV$SERVICEMETRIC
GV$SERVICEMETRIC_HISTORY
GV$SERVICES
GV$SERVICE_EVENT
GV$SERVICE_STATS
GV$SERVICE_WAIT_CLASS
GV$SERV_MOD_ACT_STATS
GV$SESSION
GV$SESSION_CONNECT_INFO
GV$SESSION_CURSOR_CACHE
GV$SESSION_EVENT
GV$SESSION_LONGOPS
GV$SESSION_OBJECT_CACHE
GV$SESSION_WAIT
GV$SESSION_WAIT_CLASS
GV$SESSION_WAIT_HISTORY
GV$SESSMETRIC
GV$SESSTAT
GV$SESS_IO
GV$SESS_TIME_MODEL
GV$SES_OPTIMIZER_ENV
GV$SGA
GV$SGAINFO
GV$SGASTAT
GV$SGA_CURRENT_RESIZE_OPS
GV$SGA_DYNAMIC_COMPONENTS
GV$SGA_DYNAMIC_FREE_MEMORY
GV$SGA_RESIZE_OPS
GV$SGA_TARGET_ADVICE
GV$SHARED_POOL_ADVICE
GV$SHARED_POOL_RESERVED
GV$SHARED_SERVER
GV$SHARED_SERVER_MONITOR
GV$SORT_SEGMENT
GV$SORT_USAGE
GV$SPPARAMETER
GV$SQL
GV$SQLAREA
GV$SQLAREA_PLAN_HASH
GV$SQLSTATS
GV$SQLTEXT
GV$SQLTEXT_WITH_NEWLINES
GV$SQL_BIND_CAPTURE
GV$SQL_BIND_DATA
GV$SQL_BIND_METADATA
GV$SQL_CURSOR
GV$SQL_JOIN_FILTER
GV$SQL_OPTIMIZER_ENV
GV$SQL_PLAN
GV$SQL_PLAN_STATISTICS
GV$SQL_PLAN_STATISTICS_ALL
GV$SQL_REDIRECTION
GV$SQL_SHARED_CURSOR
GV$SQL_SHARED_MEMORY
GV$SQL_WORKAREA
GV$SQL_WORKAREA_ACTIVE
GV$SQL_WORKAREA_HISTOGRAM
GV$STANDBY_APPLY_SNAPSHOT
GV$STANDBY_LOG
GV$STATISTICS_LEVEL
GV$STATNAME
GV$STREAMS_APPLY_COORDINATOR
GV$STREAMS_APPLY_READER
GV$STREAMS_APPLY_SERVER
GV$STREAMS_CAPTURE
GV$STREAMS_POOL_ADVICE
GV$STREAMS_TRANSACTION
GV$SUBCACHE
GV$SYSAUX_OCCUPANTS
GV$SYSMETRIC
GV$SYSMETRIC_HISTORY
GV$SYSMETRIC_SUMMARY
GV$SYSSTAT
GV$SYSTEM_CURSOR_CACHE
GV$SYSTEM_EVENT
GV$SYSTEM_PARAMETER
GV$SYSTEM_PARAMETER2
GV$SYSTEM_WAIT_CLASS
GV$SYS_OPTIMIZER_ENV
GV$SYS_TIME_MODEL
GV$TEMPFILE
GV$TEMPORARY_LOBS
GV$TEMPSEG_USAGE
GV$TEMPSTAT
GV$TEMP_CACHE_TRANSFER
GV$TEMP_EXTENT_MAP
GV$TEMP_EXTENT_POOL
GV$TEMP_HISTOGRAM
GV$TEMP_PING
GV$TEMP_SPACE_HEADER
GV$THREAD
GV$THRESHOLD_TYPES
GV$TIMER
GV$TIMEZONE_FILE
GV$TIMEZONE_NAMES
GV$TRANSACTION
GV$TRANSACTION_ENQUEUE
GV$TSM_SESSIONS
GV$TYPE_SIZE
GV$UNDOSTAT
GV$VERSION
GV$VPD_POLICY
GV$WAITCLASSMETRIC
GV$WAITCLASSMETRIC_HISTORY
GV$WAITSTAT
GV$WALLET
GV$XML_AUDIT_TRAIL
GV$_LOCK
HHAND
HHBYTELEN
HHCBIT
HHCELLBNDRY
HHCELLSIZE
HHCLDATE
HHCOLLAPSE
HHCOMMONCODE
HHCOMPARE
HHCOMPOSE
HHDECODE
HHDISTANCE
HHENCODE
HHENCODE_BYLEVEL
HHGBIT
HHGETCID
HHGROUP
HHGTBIT
HHGTYPE
HHIDLPART
HHIDPART
HHINCRLEV
HHJLDATE
HHLENGTH
HHLEVELS
HHMATCH
HHMAXCODE
HHNCOMPARE
HHNDIM
HHOR
HHORDER
HHPRECISION
HHSBIT
HHSETCID
HHSTBIT
HHSTYPE
HHSUBDIVIDE
HHSUBSTR
HHXOR
HS_ALL_CAPS
HS_ALL_DD
HS_ALL_INITS
HS_BASE_CAPS
HS_BASE_DD
HS_CLASS_CAPS
HS_CLASS_DD
HS_CLASS_INIT
HS_FDS_CLASS
HS_FDS_CLASS_DATE
HS_FDS_INST
HS_INST_CAPS
HS_INST_DD
HS_INST_INIT
HTF
HTMLDB
HTMLDB_ACTIVITY_LOG
HTMLDB_APPLICATION
HTMLDB_APPLICATION_FILES
HTMLDB_APPLICATION_GLOBAL
HTMLDB_COLLECTION
HTMLDB_COLLECTIONS
HTMLDB_CUSTOM_AUTH
HTMLDB_ITEM
HTMLDB_LANG
HTMLDB_LDAP
HTMLDB_LOGIN
HTMLDB_MAIL
HTMLDB_MAIL_LOG
HTMLDB_MAIL_QUEUE
HTMLDB_PLSQL_JOB
HTMLDB_PLSQL_JOBS
HTMLDB_SYSTEM
HTMLDB_UTIL
HTP
HTTPURITYPE
IND
INDEX_HISTOGRAM
INDEX_STATS
INTERIORRINGN
INTERSECTION
INTERSECTS
ISCLOSED
ISEMPTY
ISRING
ISSIMPLE
KU$_AUDDEF_T
KU$_AUDIT_DEFAULT_LIST_T
KU$_AUDIT_LIST_T
KU$_AUDOBJ_T
KU$_CHUNK_LIST_T
KU$_CHUNK_T
KU$_DDL
KU$_DDLS
KU$_DUMPFILE
KU$_DUMPFILE1010
KU$_DUMPFILE1020
KU$_DUMPFILESET
KU$_DUMPFILESET1010
KU$_DUMPFILESET1020
KU$_DUMPFILE_INFO
KU$_DUMPFILE_ITEM
KU$_ERRORLINE
KU$_ERRORLINES
KU$_JAVA_T
KU$_JOBDESC
KU$_JOBDESC1010
KU$_JOBDESC1020
KU$_JOBSTATUS
KU$_JOBSTATUS1010
KU$_JOBSTATUS1020
KU$_LOGENTRY
KU$_LOGENTRY1010
KU$_LOGENTRY1020
KU$_LOGLINE
KU$_LOGLINE1010
KU$_LOGLINE1020
KU$_MULTI_DDL
KU$_MULTI_DDLS
KU$_OBJNUMPAIR
KU$_OBJNUMPAIRLIST
KU$_OBJNUMSET
KU$_PARAMVALUE
KU$_PARAMVALUE1010
KU$_PARAMVALUE1020
KU$_PARAMVALUES
KU$_PARAMVALUES1010
KU$_PARAMVALUES1020
KU$_PARSED_ITEM
KU$_PARSED_ITEMS
KU$_PROCOBJ_LINE
KU$_PROCOBJ_LINES
KU$_PROCOBJ_LOC
KU$_PROCOBJ_LOCS
KU$_SOURCE_LIST_T
KU$_SOURCE_T
KU$_STATUS
KU$_STATUS1010
KU$_STATUS1020
KU$_SUBMITRESULT
KU$_SUBMITRESULTS
KU$_TACTION_LIST_T
KU$_TACTION_T
KU$_VCNT
KU$_WORKERSTATUS
KU$_WORKERSTATUS1010
KU$_WORKERSTATUS1020
KU$_WORKERSTATUSLIST
KU$_WORKERSTATUSLIST1010
KU$_WORKERSTATUSLIST1020
KUPCC
LINESTRING
LINESTRINGFROMTEXT
LINESTRINGFROMWKB
LOADER_COL_FLAGS
LOADER_COL_INFO
LOADER_COL_TYPE
LOADER_CONSTRAINT_INFO
LOADER_DIR_OBJS
LOADER_FILE_TS
LOADER_FULL_ATTR_NAME
LOADER_INTCOL_INFO
LOADER_LOB_FLAGS
LOADER_NESTED_VARRAYS
LOADER_OID_INFO
LOADER_PARAM_INFO
LOADER_PART_INFO
LOADER_REF_INFO
LOADER_SKIP_UNUSABLE_INDEXES
LOADER_TAB_INFO
LOADER_TRIGGER_INFO
LOCATOR_WITHIN_DISTANCE
MAP_OBJECT
MATCHES
MATCH_SCORE
MD
MD_LRS
MULTICURVE
MULTILINESTRING
MULTILINESTRINGFROMTEXT
MULTILINESTRINGFROMWKB
MULTIPOINT
MULTIPOLYGON
MULTIPOLYGONFROMTEXT
MULTIPOLYGONFROMWKB
MULTISURFACE
MY_SDO_INDEX_METADATA
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
NUMGEOMETRIES
NUMINTERIORRINGS
NUMPOINTS
NV
OBJ
ODCICONST
ODM_UTIL
OGC_CONTAINS
OGC_LENGTH
OGC_UNION
OGIS_GEOMETRY_COLUMNS
OGIS_SPATIAL_REFERENCE_SYSTEMS
OL$
OL$HINTS
OL$NODES
OLAP_BOOL_SRF
OLAP_CONDITION
OLAP_DATE_SRF
OLAP_EXPRESSION
OLAP_EXPRESSION_BOOL
OLAP_EXPRESSION_DATE
OLAP_EXPRESSION_TEXT
OLAP_NUMBER_SRF
OLAP_SRF_T
OLAP_TEXT_SRF
ORA_CLIENT_IP_ADDRESS
ORA_DATABASE_NAME
ORA_DES_ENCRYPTED_PASSWORD
ORA_DICT_OBJ_NAME
ORA_DICT_OBJ_NAME_LIST
ORA_DICT_OBJ_OWNER
ORA_DICT_OBJ_OWNER_LIST
ORA_DICT_OBJ_TYPE
ORA_DM_TREE_NODES
ORA_FI_DECISION_TREE_HORIZ
ORA_GRANTEE
ORA_INSTANCE_NUM
ORA_IS_ALTER_COLUMN
ORA_IS_DROP_COLUMN
ORA_IS_SERVERERROR
ORA_KGLR7_DB_LINKS
ORA_KGLR7_DEPENDENCIES
ORA_KGLR7_IDL_CHAR
ORA_KGLR7_IDL_SB4
ORA_KGLR7_IDL_UB1
ORA_KGLR7_IDL_UB2
ORA_LOGIN_USER
ORA_PARTITION_POS
ORA_PRIVILEGE_LIST
ORA_REVOKEE
ORA_SERVER_ERROR
ORA_SERVER_ERROR_DEPTH
ORA_SERVER_ERROR_MSG
ORA_SERVER_ERROR_NUM_PARAMS
ORA_SERVER_ERROR_PARAM
ORA_SPACE_ERROR_INFO
ORA_SQL_TXT
ORA_SYSEVENT
ORA_WITH_GRANT_OPTION
OUTLINE
OUTLN_PKG
OVERLAP
OWA
OWA_CACHE
OWA_COOKIE
OWA_CUSTOM
OWA_GLOBAL
OWA_IMAGE
OWA_INIT
OWA_MATCH
OWA_OPT_LOCK
OWA_PATTERN
OWA_SEC
OWA_TEXT
OWA_UTIL
P
PATH
PATH_VIEW
PBSDE
PLITBLM
POINT
POINTFROMTEXT
POINTFROMWKB
POINTN
POINTONSURFACE
POLYGON
POLYGONFROMTEXT
POLYGONFROMWKB
PRODUCT_COMPONENT_VERSION
PRODUCT_PROFILE
PRODUCT_USER_PROFILE
PROXY_ROLES
PROXY_USERS
PROXY_USERS_AND_ROLES
PUBLIC_DEPENDENCY
QUEUE_PRIVILEGES
RECYCLEBIN
RELATE
REPCAT_REPCOLUMN_BASE
RESOURCE_COST
RESOURCE_VIEW
REWRITEARRAYTYPE
REWRITEMESSAGE
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
RTREEJOINFUNC
SCHEMA_EXPORT_OBJECTS
SCN_TO_TIMESTAMP
SCORE
SDO
SDOAGGRTYPE
SDO_3GL
SDO_ADDR_ARRAY
SDO_ADMIN
SDO_AGGR_CENTROID
SDO_AGGR_CONCAT_LINES
SDO_AGGR_CONVEXHULL
SDO_AGGR_LRS_CONCAT
SDO_AGGR_LRS_CONCAT_3D
SDO_AGGR_MBR
SDO_AGGR_UNION
SDO_ANGLE_UNITS
SDO_ANYINTERACT
SDO_AREA_UNITS
SDO_AVAILABLE_ELEM_OPS
SDO_AVAILABLE_NON_ELEM_OPS
SDO_AVAILABLE_OPS
SDO_CATALOG
SDO_CONTAINS
SDO_COORD_AXES
SDO_COORD_AXIS_NAMES
SDO_COORD_OPS
SDO_COORD_OP_METHODS
SDO_COORD_OP_PARAMS
SDO_COORD_OP_PARAM_USE
SDO_COORD_OP_PARAM_VALS
SDO_COORD_OP_PATHS
SDO_COORD_REF_SYS
SDO_COORD_REF_SYSTEM
SDO_COORD_SYS
SDO_COVEREDBY
SDO_COVERS
SDO_CRS_COMPOUND
SDO_CRS_ENGINEERING
SDO_CRS_GEOCENTRIC
SDO_CRS_GEOGRAPHIC2D
SDO_CRS_GEOGRAPHIC3D
SDO_CRS_PROJECTED
SDO_CRS_VERTICAL
SDO_CS
SDO_DATUMS
SDO_DATUMS_OLD_FORMAT
SDO_DATUMS_OLD_SNAPSHOT
SDO_DATUM_ENGINEERING
SDO_DATUM_GEODETIC
SDO_DATUM_VERTICAL
SDO_DIM_ARRAY
SDO_DIM_ELEMENT
SDO_DIST_UNITS
SDO_EDGE_ARRAY
SDO_ELEM_INFO_ARRAY
SDO_ELLIPSOIDS
SDO_ELLIPSOIDS_OLD_FORMAT
SDO_ELLIPSOIDS_OLD_SNAPSHOT
SDO_EQUAL
SDO_FILTER
SDO_GEOM
SDO_GEOMETRY
SDO_GEO_ADDR
SDO_INDEX_METADATA
SDO_INSIDE
SDO_JOIN
SDO_KEYWORDARRAY
SDO_LIST_TYPE
SDO_LRS
SDO_MBR
SDO_MIGRATE
SDO_NN
SDO_NN_DISTANCE
SDO_NUMBER_ARRAY
SDO_ON
SDO_ORDINATE_ARRAY
SDO_OVERLAPBDYDISJOINT
SDO_OVERLAPBDYINTERSECT
SDO_OVERLAPS
SDO_POINT_TYPE
SDO_PREFERRED_OPS_SYSTEM
SDO_PREFERRED_OPS_USER
SDO_PRIDX
SDO_PRIME_MERIDIANS
SDO_PROJECTIONS_OLD_FORMAT
SDO_PROJECTIONS_OLD_SNAPSHOT
SDO_REGAGGR
SDO_REGAGGRSET
SDO_REGION
SDO_REGIONSET
SDO_RELATE
SDO_RELATE_MASK
SDO_ROWIDPAIR
SDO_ROWIDSET
SDO_RTREE_ADMIN
SDO_RTREE_FILTER
SDO_RTREE_RELATE
SDO_SRID_CHAIN
SDO_SRID_LIST
SDO_STRING_ARRAY
SDO_TFM_CHAIN
SDO_TGL_OBJECT
SDO_TGL_OBJECT_ARRAY
SDO_TOPO_DATA$
SDO_TOPO_GEOMETRY
SDO_TOPO_GEOMETRY_LAYER
SDO_TOPO_GEOMETRY_LAYER_ARRAY
SDO_TOPO_NSTD_TBL
SDO_TOPO_OBJECT
SDO_TOPO_OBJECT_ARRAY
SDO_TOPO_TRANSACT_DATA$
SDO_TOUCH
SDO_TRANSIENT_RULE
SDO_TRANSIENT_RULE_SET
SDO_TUNE
SDO_TXN_IDX_DELETES
SDO_TXN_IDX_EXP_UPD_RGN
SDO_TXN_IDX_INSERTS
SDO_UNITS_OF_MEASURE
SDO_UTIL
SDO_VERSION
SDO_VPOINT_TYPE
SDO_WITHIN_DISTANCE
SEQ
SESSION_CONTEXT
SESSION_PRIVS
SESSION_ROLES
SM$VERSION
SPATIAL_INDEX
SQLPROF_ATTR
SQLSET
SQLSET_ROW
SQL_BIND
SQL_BINDS
SQL_BIND_SET
SQL_OBJECTS
SQL_PLAN_ROW_TYPE
SQL_PLAN_STAT_ROW_TYPE
SRID
STARTPOINT
STMT_AUDIT_OPTION_MAP
SURFACE
SYMMETRICDIFFERENCE
SYN
SYSTEM_PRIVILEGE_MAP
SYS_IXQAGG
SYS_NT_COLLECT
SYS_XMLAGG
TEMP$LOB
TFM_PLAN
TIMESTAMP_TO_SCN
TMP_COORD_OPS
TOUCH
TRUSTED_SERVERS
UNDER_PATH
URIFACTORY
URITYPE
USER_
UTL_
V
V$
WITHIN
WPG_DOCLOAD
WWV_
X
XDB$STRING_LIST_T
XDBURITYPE
XDB_PVTRIG_PKG
XDB_RVTRIG_PKG
XMLAGG
XMLDOM
XMLFORMAT
XMLPARSER
XMLSEQUENCE
XMLSEQUENCETYPE
XMLTYPE
XQSEQUENCE
XSLPROCESSOR
Y
Z
_ALL_INSTANTIATION_DDL
_ALL_REPEXTENSIONS
_ALL_REPSITES_NEW
_ALL_SQLSET_STATEMENTS_ONLY
_ALL_SQLSET_STATEMENTS_PHV
_ALL_SQLSET_STATISTICS_ONLY
SCHEDULER$_JOBSUFFIX_S
AUDIT_ACTIONS
DUAL
IMPDP_STATS
KU$NOEXP_TAB
ODCI_SECOBJ$
ODCI_WARNINGS$
PSTUBTBL
STMT_AUDIT_OPTION_MAP
SYSTEM_PRIVILEGE_MAP
WRI$_ADV_ASA_RECO_DATA
DEF$_TEMP$LOB
HELP
OL$
OL$HINTS
OL$NODES
ALL_
CATALOG
COL
COLUMN_PRIVILEGES
DATABASE_COMPATIBLE_LEVEL
DATABASE_EXPORT_OBJECTS
DATABASE_PROPERTIES
DATAPUMP_DDL_TRANSFORM_PARAMS
DATAPUMP_OBJECT_CONNECT
DATAPUMP_PATHMAP
DATAPUMP_PATHS
DATAPUMP_REMAP_OBJECTS
DBA_AUTO_SEGADV_CTL
DBA_AUTO_SEGADV_SUMMARY
DEFERRCOUNT
DICTIONARY
DICT_COLUMNS
EXPCOMPRESSEDPART
EXPCOMPRESSEDSUB
EXPCOMPRESSEDTAB
EXPEXEMPT
EXPGETENCCOLNAM
EXPTABSUBPART
EXPTABSUBPARTDATA_VIEW
EXPTABSUBPARTLOBFRAG
EXPTABSUBPARTLOB_VIEW
EXU102XTYPU
EXU10ADEFPSWITCHES
EXU10AOBJSWITCH
EXU10ASCU
EXU10CCLO
EXU10CCLU
EXU10COEU
EXU10DEFPSWITCHES
EXU10DOSO
EXU10IND_BASE
EXU10LNKU
EXU10MVL
EXU10MVLU
EXU10OBJSWITCH
EXU10R2DEFPSWITCHES
EXU10R2OBJSWITCH
EXU10SNAPLU
EXU10SNAPU
EXU10TABSU
EXU10TABU
EXU816MAXSQV
EXU816TGRU
EXU81ACTIONOBJ
EXU81ACTIONPKG
EXU81ASSOC
EXU81CSC
EXU81DOIU
EXU81IND
EXU81IND_BASE
EXU81ITYU
EXU81IXCPU
EXU81IXSPU
EXU81JAV
EXU81JAVT
EXU81LBCPU
EXU81LBPU
EXU81LBSPU
EXU81NOS
EXU81OBJECTPKG
EXU81OPRU
EXU81PLBU
EXU81PROCOBJ
EXU81PROCOBJINSTANCE
EXU81RGCU
EXU81RGSU
EXU81RLS
EXU81SCMU
EXU81SLFCU
EXU81SNAPLU
EXU81SNAPU
EXU81SPOKIU
EXU81SPOKU
EXU81SRTU
EXU81TABSU
EXU81TABU
EXU81TBCPU
EXU81TBSPU
EXU81TGRU
EXU81TYPU
EXU81USCIU
EXU8ANAL
EXU8ASCU
EXU8BSZ
EXU8CCLO
EXU8CCLU
EXU8CCOU
EXU8CGRU
EXU8CLUU
EXU8CMTU
EXU8COEU
EXU8COLU
EXU8CONU
EXU8COOU
EXU8CPO
EXU8CSET
EXU8CSNU
EXU8DIM
EXU8DIMU
EXU8FPTU
EXU8FUL
EXU8GLOB
EXU8GRNU
EXU8HSTU
EXU8ICO
EXU8ICOU
EXU8ICPLSQL
EXU8INDU
EXU8INKU
EXU8IOVU
EXU8IXPU
EXU8JBQU
EXU8LIBU
EXU8LNKU
EXU8LOBU
EXU8NTBU
EXU8NXPU
EXU8OIDU
EXU8OPT
EXU8ORD
EXU8ORDU
EXU8ORFS
EXU8PDSU
EXU8PNTU
EXU8POKIU
EXU8POKU
EXU8PSTU
EXU8REFU
EXU8RFSU
EXU8RGCU
EXU8RGSU
EXU8SCMU
EXU8SEQU
EXU8SLFCU
EXU8SLOGU
EXU8SNAPLU
EXU8SNAPU
EXU8SPSU
EXU8SPU
EXU8SRTU
EXU8STOU
EXU8SYNU
EXU8TABU
EXU8TBPU
EXU8TGRU
EXU8TNE
EXU8TNEB
EXU8TYPBU
EXU8TYPTU
EXU8TYPU
EXU8USCU
EXU8USRU
EXU8VDPTU
EXU8VER
EXU8VEWU
EXU8VINFU
EXU8VNCU
EXU92FPTPU
EXU92FPTU
EXU92TGRU
EXU92TSP
EXU92TSPL
EXU9ACTIONOBJ
EXU9BJF
EXU9BJW
EXU9CCLO
EXU9CCLU
EXU9COEU
EXU9COOU
EXU9DEFPSWITCHES
EXU9DOIU
EXU9DOSO
EXU9EIP
EXU9FGA
EXU9GSAS
EXU9IND
EXU9IND_BASE
EXU9INHCOLCONS
EXU9IXCPU
EXU9LBCPU
EXU9LBPU
EXU9LNKU
EXU9LOBU
EXU9MVL
EXU9MVLCDCCC
EXU9MVLCDCS
EXU9MVLCDCSC
EXU9MVLCDCST
EXU9MVLU
EXU9NLS
EXU9NOS
EXU9OBJSWITCH
EXU9OTNNULL
EXU9PCT
EXU9PDSU
EXU9PGP
EXU9PLBU
EXU9PTS
EXU9RLS
EXU9SNAPLU
EXU9SNAPU
EXU9STOU
EXU9SYNU
EXU9TABSU
EXU9TABU
EXU9TAB_UNUSED_COLS
EXU9TBCPU
EXU9TNE
EXU9TNEB
EXU9TYPTU
EXU9TYPTU2
EXU9TYPU
EXU9UTSU
EXU9XDBUID
EXU9XMLST
EXU9XTB
FLASHBACK_TRANSACTION_QUERY
GLOBAL_CONTEXT
GLOBAL_NAME
GV_$ACTIVE_INSTANCES
GV_$ACTIVE_SESS_POOL_MTH
GV_$AW_AGGREGATE_OP
GV_$AW_ALLOCATE_OP
GV_$AW_CALC
GV_$AW_LONGOPS
GV_$AW_OLAP
GV_$AW_SESSION_INFO
GV_$BH
GV_$BLOCKING_QUIESCE
GV_$LOADISTAT
GV_$LOADPSTAT
GV_$LOCK_ACTIVITY
GV_$MAX_ACTIVE_SESS_TARGET_MTH
GV_$NLS_PARAMETERS
GV_$NLS_VALID_VALUES
GV_$OPTION
GV_$PARALLEL_DEGREE_LIMIT_MTH
GV_$PQ_SESSTAT
GV_$PQ_TQSTAT
GV_$QUEUEING_MTH
GV_$RESTORE_POINT
GV_$RSRC_CONSUMER_GROUP
GV_$RSRC_CONSUME_GROUP_CPU_MTH
GV_$RSRC_CONS_GROUP_HISTORY
GV_$RSRC_PLAN
GV_$RSRC_PLAN_CPU_MTH
GV_$RSRC_PLAN_HISTORY
GV_$RSRC_SESSION_INFO
GV_$SESSION_LONGOPS
GV_$TEMPORARY_LOBS
GV_$TIMEZONE_FILE
GV_$TIMEZONE_NAMES
GV_$VERSION
IMP8CDTU
IMP8REPCAT
IMP8TTDU
IMP8UEC
IMP9COMPAT
IMP9SYN4
IMP9TVOID
IMP9USR
IMP_LOB_INFO
IMP_LOB_NOTNULL
IMP_TAB_TRIG
INDEX_HISTOGRAM
INDEX_STATS
KU$
KU_NOEXP_VIEW
LOADER_
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
ORA_KGLR7_DB_LINKS
ORA_KGLR7_DEPENDENCIES
ORA_KGLR7_IDL_CHAR
ORA_KGLR7_IDL_SB4
ORA_KGLR7_IDL_UB1
ORA_KGLR7_IDL_UB2
PRODUCT_COMPONENT_VERSION
PUBLICSYN
PUBLIC_DEPENDENCY
QUEUE_PRIVILEGES
RESOURCE_COST
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SCHEMA_EXPORT_OBJECTS
SESSION_CONTEXT
SESSION_PRIVS
SESSION_ROLES
SM_$VERSION
SYNONYMS
SYSCATALOG
SYSFILES
SYSSEGOBJ
USER_
UTL_ALL_IND_COMPS
V$OBJECT_USAGE
V_$ACTIVE_INSTANCES
V_$ACTIVE_SESS_POOL_MTH
V_$ADVISOR_PROGRESS
V_$AW_AGGREGATE_OP
V_$AW_ALLOCATE_OP
V_$AW_CALC
V_$AW_LONGOPS
V_$AW_OLAP
V_$AW_SESSION_INFO
V_$BH
V_$BLOCKING_QUIESCE
V_$LOADISTAT
V_$LOADPSTAT
V_$LOCK_ACTIVITY
V_$MAX_ACTIVE_SESS_TARGET_MTH
V_$NLS_PARAMETERS
V_$NLS_VALID_VALUES
V_$OPTION
V_$PARALLEL_DEGREE_LIMIT_MTH
V_$PQ_SESSTAT
V_$PQ_TQSTAT
V_$QUEUEING_MTH
V_$RESTORE_POINT
V_$RSRC_CONSUMER_GROUP
V_$RSRC_CONSUMER_GROUP_CPU_MTH
V_$RSRC_CONS_GROUP_HISTORY
V_$RSRC_PLAN
V_$RSRC_PLAN_CPU_MTH
V_$RSRC_PLAN_HISTORY
V_$RSRC_SESSION_INFO
V_$SESSION_CONNECT_INFO
V_$SESSION_LONGOPS
V_$TEMPORARY_LOBS
V_$TIMEZONE_FILE
V_$TIMEZONE_NAMES
V_$VERSION
_ALL_FILE_GROUPS
_ALL_FILE_GROUP_EXPORT_INFO
_ALL_FILE_GROUP_FILES
_ALL_FILE_GROUP_TABLES
_ALL_FILE_GROUP_TABLESPACES
_ALL_FILE_GROUP_VERSIONS
_ALL_INSTANTIATION_DDL
_ALL_REPCOLUMN
_ALL_REPCOLUMN_GROUP
_ALL_REPCONFLICT
_ALL_REPEXTENSIONS
_ALL_REPFLAVOR_OBJECTS
_ALL_REPGROUPED_COLUMN
_ALL_REPPARAMETER_COLUMN
_ALL_REPRESOLUTION
_ALL_REPSITES_NEW
_ALL_SQLSET_STATEMENTS_ONLY
_ALL_SQLSET_STATEMENTS_PHV
_ALL_SQLSET_STATISTICS_ONLY
PRODUCT_PRIVS
DR$NUMBER_SEQUENCE
DR$OBJECT_ATTRIBUTE
DR$POLICY_TAB
BIN$qoPod3b/5/jgQAB/AQB1gw==$0
BIN$qoa+IroQdCDgQAB/AQAShg==$0
BIN$qoa+gX3av6bgQAB/AQASoA==$0
BIN$qoa97kXfAGHgQAB/AQASdw==$0
BIN$qoaJ7wJwYOLgQAB/AQAITA==$0
BIN$qoamIR+TOebgQAB/AQANmw==$0
BIN$qoamP2m44xXgQAB/AQANoA==$0
BIN$qoamm6N5i3bgQAB/AQANtg==$0
BIN$qob17xzsmp3gQAB/AQAgOA==$0
BIN$qod/Sxxh583gQAB/AQAGVg==$0
BIN$qod/pFQZipXgQAB/AQAGaw==$0
WWV_FLOW_DUAL100
WWV_FLOW_FIELD_TEMPLATES
WWV_FLOW_LISTS_OF_VALUES$
WWV_FLOW_LIST_OF_VALUES_DATA
WWV_FLOW_LOV_TEMP
WWV_FLOW_PATCHES
WWV_FLOW_TEMP_TABLE
OGIS_GEOMETRY_COLUMNS
OGIS_SPATIAL_REFERENCE_SYSTEMS
SDO_COORD_AXES
SDO_COORD_AXIS_NAMES
SDO_COORD_OPS
SDO_COORD_OP_METHODS
SDO_COORD_OP_PARAMS
SDO_COORD_OP_PARAM_USE
SDO_COORD_OP_PARAM_VALS
SDO_COORD_OP_PATHS
SDO_COORD_REF_SYS
SDO_COORD_SYS
SDO_CS_SRS
SDO_DATUMS
SDO_DATUMS_OLD_SNAPSHOT
SDO_ELLIPSOIDS
SDO_ELLIPSOIDS_OLD_SNAPSHOT
SDO_PREFERRED_OPS_SYSTEM
SDO_PREFERRED_OPS_USER
SDO_PRIME_MERIDIANS
SDO_PROJECTIONS_OLD_SNAPSHOT
SDO_TOPO_DATA$
SDO_TOPO_RELATION_DATA
SDO_TOPO_TRANSACT_DATA
SDO_TXN_IDX_DELETES
SDO_TXN_IDX_EXP_UPD_RGN
SDO_TXN_IDX_INSERTS
SDO_UNITS_OF_MEASURE
XDB$ACL
XDB$ALL_MODEL
XDB$ANY
XDB$ANYATTR
XDB$ATTRGROUP_DEF
XDB$ATTRGROUP_REF
XDB$ATTRIBUTE
XDB$CHOICE_MODEL
XDB$COMPLEX_TYPE
XDB$ELEMENT
XDB$GROUP_DEF
XDB$GROUP_REF
XDB$SCHEMA
XDB$SEQUENCE_MODEL
XDB$SIMPLE_TYPE
CTX_CLASSES
CTX_INDEX_SETS
CTX_INDEX_SET_INDEXES
CTX_OBJECTS
CTX_OBJECT_ATTRIBUTES
CTX_OBJECT_ATTRIBUTE_LOV
CTX_PARAMETERS
CTX_PREFERENCES
CTX_PREFERENCE_VALUES
CTX_SECTIONS
CTX_SECTION_GROUPS
CTX_SQES
CTX_STOPLISTS
CTX_STOPWORDS
CTX_SUB_LEXERS
CTX_THESAURI
CTX_THES_PHRASES
CTX_TRACE_VALUES
CTX_USER_INDEXES
CTX_USER_INDEX_ERRORS
CTX_USER_INDEX_OBJECTS
CTX_USER_INDEX_PARTITIONS
CTX_USER_INDEX_SETS
CTX_USER_INDEX_SET_INDEXES
CTX_USER_INDEX_SUB_LEXERS
CTX_USER_INDEX_SUB_LEXER_VALS
CTX_USER_INDEX_VALUES
CTX_USER_PENDING
CTX_USER_PREFERENCES
CTX_USER_PREFERENCE_VALUES
CTX_USER_SECTIONS
CTX_USER_SECTION_GROUPS
CTX_USER_SQES
CTX_USER_STOPLISTS
CTX_USER_STOPWORDS
CTX_USER_SUB_LEXERS
CTX_USER_THESAURI
CTX_USER_THES_PHRASES
DRV$DELETE
DRV$DELETE2
DRV$ONLINE_PENDING
DRV$PENDING
DRV$UNINDEXED
DRV$UNINDEXED2
DRV$WAITING
WWV_FLOW_CLICKTHRU_LOG
WWV_FLOW_COLLECTIONS
WWV_FLOW_FILES
WWV_FLOW_GROUP_USERS
WWV_FLOW_HOURS_12
WWV_FLOW_HOURS_24
WWV_FLOW_MINUTES
WWV_FLOW_MINUTES_5
WWV_FLOW_MONTHS_MON
WWV_FLOW_MONTHS_MONTH
WWV_FLOW_PLSQL_JOBS
WWV_FLOW_USERS
WWV_FLOW_USER_ACTIVITY_LOG
WWV_FLOW_USER_MAIL_LOG
WWV_FLOW_USER_MAIL_QUEUE
WWV_FLOW_YEARS
ALL_GEOMETRY_COLUMNS
ALL_SDO_GEOM_METADATA
ALL_SDO_INDEX_INFO
ALL_SDO_INDEX_METADATA
ALL_SDO_LRS_METADATA
ALL_SDO_MAPS
ALL_SDO_STYLES
ALL_SDO_THEMES
ALL_SDO_TOPO_INFO
ALL_SDO_TOPO_METADATA
CS_SRS
DBA_SDO_MAPS
DBA_SDO_STYLES
DBA_SDO_THEMES
GEODETIC_SRIDS
MY_SDO_INDEX_METADATA
SDO_ANGLE_UNITS
SDO_AREA_UNITS
SDO_AVAILABLE_ELEM_OPS
SDO_AVAILABLE_NON_ELEM_OPS
SDO_AVAILABLE_OPS
SDO_COORD_REF_SYSTEM
SDO_CRS_COMPOUND
SDO_CRS_ENGINEERING
SDO_CRS_GEOCENTRIC
SDO_CRS_GEOGRAPHIC2D
SDO_CRS_GEOGRAPHIC3D
SDO_CRS_PROJECTED
SDO_CRS_VERTICAL
SDO_DATUMS_OLD_FORMAT
SDO_DATUM_ENGINEERING
SDO_DATUM_GEODETIC
SDO_DATUM_VERTICAL
SDO_DIST_UNITS
SDO_ELLIPSOIDS_OLD_FORMAT
SDO_PROJECTIONS_OLD_FORMAT
SDO_RELATEMASK_TABLE
SDO_TOPO_TRANSACT_DATA$
USER_
PATH_VIEW
RESOURCE_VIEW
CHANGE_TABLES
DATAPUMP_TABLE_DATA
GV$DB_TRANSPORTABLE_PLATFORM
GV$FIXED_TABLE
GV$TABLESPACE
GV$TRANSPORTABLE_PLATFORM
OLAPRC_TABLE
OLAP_TABLE
ORA_IS_CREATING_NESTED_TABLE
SQL_PLAN_TABLE_TYPE
TABLESPACE_EXPORT_OBJECTS
TABLE_EXPORT_OBJECTS
TABLE_PRIVILEGES
TABLE_PRIVILEGE_MAP
TABQUOTAS
TABS
TRANSPORTABLE_EXPORT_OBJECTS
#;
@system_tables = map {quotemeta $_} @system_tables;
push @system_tables, 'BIN';
my $system_table_re = '^(' . join('|', @system_tables) . ')';
has exclude_table => sub {
return $system_table_re;
};
has dsn => 'dbi:Oracle:host=localhost;port=1521;sid=XE';
has user => 'dbix_custom';
has password => 'dbix_custom';
sub create_table1 { "create table $table1 ($key1 varchar2(255), $key2 varchar2(255))" }
sub create_table1_2 { "create table $table1 ($key1 varchar2(255), $key2 varchar2(255), "
. "$key3 varchar2(255), $key4 varchar2(255), $key5 varchar2(255))" }
sub create_table1_type { "create table $table1 ($key1 $date_typename, $key2 $datetime_typename)" }
sub create_table1_highperformance { "create table $table1 ($key1 varchar2(255), $key2 varchar2(255), "
. "$key3 varchar2(255), $key4 varchar2(255), $key5 varchar2(255), $key6 varchar2(255), $key7 varchar2(255))" }
sub create_table2 { "create table $table2 ($key1 varchar2(255), $key3 varchar2(255))" }
sub create_table2_2 { "create table $table2 ($key1 varchar2(255), $key2 varchar2(255), $key3 varchar2(255))" }
sub create_table3 { "create table $table3 ($key1 varchar2(255), $key2 varchar2(255), $key3 varchar2(255))" }
sub create_table_reserved { 'create table "table" ("select" varchar2(255), "update" varchar2(255))' }
}
require "$FindBin::Bin/common.t";