ken/DBIx-Custom at c7f934b262ff294e446dff3e14e646afdb4c6a46 ・ Gitprep

DBIx-Custom / t / common-oracle.t /

Newer ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ Older

1662 lines | 40.057kb

prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	1	use strict;
	2	use warnings;
	3
	4	use FindBin;
	5	$ENV{DBIX_CUSTOM_TEST_RUN} = 1
	6	if -f "$FindBin::Bin/run/common-oracle.run";
	7	$ENV{DBIX_CUSTOM_SKIP_MESSAGE} = 'oracle private test';
	8
	9	use DBIx::Custom;
	10	{
	11	package DBIx::Custom;
	12	no warnings 'redefine';
test cleanup c7f934b Yuki Kimoto authored on 2011-08-15	13
	14	has dbi_option => sub {
	15	{
	16	Callbacks => {
	17	connected => sub {
	18	shift->do(
	19	"ALTER SESSION SET NLS_DATE_FORMAT = 'RR-MM-DD HH24:MI:SS'"
	20	);
	21	return;
	22	},
	23	}
	24	}
	25	};
prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	26
cleanup test f60e789 Yuki Kimoto authored on 2011-08-15	27	my $table1 = 'TABLE1';
	28	my $table2 = 'TABLE2';
	29	my $table2_alias = 'TABLE2_ALIAS';
	30	my $table3 = 'TABLE3';
	31	my $key1 = 'KEY1';
	32	my $key2 = 'KEY2';
	33	my $key3 = 'KEY3';
	34	my $key4 = 'KEY4';
	35	my $key5 = 'KEY5';
	36	my $key6 = 'KEY6';
	37	my $key7 = 'KEY7';
	38	my $key8 = 'KEY8';
	39	my $key9 = 'KEY9';
	40	my $key10 = 'KEY10';
	41
	42	has table1 => $table1;
	43	has table2 => $table2;
	44	has table2_alias => $table2_alias;
	45	has table3 => $table3;
	46	has key1 => $key1;
	47	has key2 => $key2;
	48	has key3 => $key3;
	49	has key4 => $key4;
	50	has key5 => $key5;
	51	has key6 => $key6;
	52	has key7 => $key7;
	53	has key8 => $key8;
	54	has key9 => $key9;
	55	has key10 => $key10;
	56
prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	57	my $date_typename = 'CHAR(10)';
	58	my $datetime_typename = 'DATE';
	59
	60	sub date_typename { lc 'CHAR' }
	61	sub datetime_typename { lc $datetime_typename }
	62
test cleanup c7f934b Yuki Kimoto authored on 2011-08-15	63	my $date_datatype = 1;
	64	my $datetime_datatype = 93;
prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	65
	66	sub date_datatype { lc $date_datatype }
	67	sub datetime_datatype { lc $datetime_datatype }
test cleanup c7f934b Yuki Kimoto authored on 2011-08-15	68
	69	my @system_tables = qw#
	70	WWV_FLOW_SESSION_SEQ
	71	WWV_SEQ
	72	SAMPLE_SEQ
	73	SDO_IDX_TAB_SEQUENCE
	74	TMP_COORD_OPS
	75	XDB$NAMESUFF_SEQ
	76	ABSPATH
	77	ALERT_TYPE
	78	ALL_
	79	ANYDATA
	80	ANYDATASET
	81	ANYTYPE
	82	APEX
	83	APPLICATION_AUTHENTICATION
	84	AQ$INTERNET_USERS
	85	AREA
	86	ASBINARY
	87	ASTEXT
	88	AUDIT_ACTIONS
	89	AWRDRPT_TEXT_TYPE
	90	AWRRPT_CLB_ARY
	91	AWRRPT_HTML_TYPE
	92	AWRRPT_NUM_ARY
	93	AWRRPT_ROW_TYPE
	94	AWRRPT_TEXT_TYPE
	95	AWRRPT_VCH_ARY
	96	AWRSQRPT_TEXT_TYPE
	97	BOUNDARY
	98	BUFFER
	99	CAT
	100	CATSEARCH
	101	CENTROID
	102	CHANGE_PROPAGATIONS
	103	CHANGE_PROPAGATION_SETS
	104	CHANGE_SETS
	105	CHANGE_SOURCES
	106	CIRCULARSTRING
	107	CLU
	108	COL
	109	COLLECT
	110	COLS
	111	COLUMN_PRIVILEGES
	112	COMPOUNDCURVE
	113	CONTAINS
	114	CONTENTSCHEMAIS
	115	CONTEXT
	116	CONVEXHULL
	117	CROSS
	118	CS_SRS
	119	CTXCAT
	120	CTXRULE
	121	CTXXPATH
	122	CTX_CLASSES
	123	CTX_CLS
	124	CTX_DDL
	125	CTX_DOC
	126	CTX_INDEX_SETS
	127	CTX_INDEX_SET_INDEXES
	128	CTX_OBJECTS
	129	CTX_OBJECT_ATTRIBUTES
	130	CTX_OBJECT_ATTRIBUTE_LOV
	131	CTX_OUTPUT
	132	CTX_PARAMETERS
	133	CTX_PREFERENCES
	134	CTX_PREFERENCE_VALUES
	135	CTX_QUERY
	136	CTX_REPORT
	137	CTX_SECTIONS
	138	CTX_SECTION_GROUPS
	139	CTX_SQES
	140	CTX_STOPLISTS
	141	CTX_STOPWORDS
	142	CTX_SUB_LEXERS
	143	CTX_THES
	144	CTX_THESAURI
	145	CTX_THES_PHRASES
	146	CTX_TRACE_VALUES
	147	CTX_ULEXER
	148	CTX_USER_INDEXES
	149	CTX_USER_INDEX_ERRORS
	150	CTX_USER_INDEX_OBJECTS
	151	CTX_USER_INDEX_PARTITIONS
	152	CTX_USER_INDEX_SETS
	153	CTX_USER_INDEX_SET_INDEXES
	154	CTX_USER_INDEX_SUB_LEXERS
	155	CTX_USER_INDEX_SUB_LEXER_VALS
	156	CTX_USER_INDEX_VALUES
	157	CTX_USER_PENDING
	158	CTX_USER_PREFERENCES
	159	CTX_USER_PREFERENCE_VALUES
	160	CTX_USER_SECTIONS
	161	CTX_USER_SECTION_GROUPS
	162	CTX_USER_SQES
	163	CTX_USER_STOPLISTS
	164	CTX_USER_STOPWORDS
	165	CTX_USER_SUB_LEXERS
	166	CTX_USER_THESAURI
	167	CTX_USER_THES_PHRASES
	168	CURVE
	169	CURVEPOLYGON
	170	DATABASE_COMPATIBLE_LEVEL
	171	DATABASE_EXPORT_OBJECTS
	172	DATABASE_PROPERTIES
	173	DATAPUMP_OBJECT_CONNECT
	174	DATAPUMP_PATHMAP
	175	DATAPUMP_PATHS
	176	DATAPUMP_REMAP_OBJECTS
	177	DBA_2PC_NEIGHBORS
	178	DBA_
	179	DBMSHSXP
	180	DBMSHSXP_SQL_PROFILE_ATTR
	181	DBMSOBJGWRAPPER
	182	DBMSOUTPUT_LINESARRAY
	183	DBMSZEXP_SYSPKGGRNT
	184	DBMS_
	185	DBURITYPE
	186	DEFCALL
	187	DEFCALLDEST
	188	DEFDEFAULTDEST
	189	DEFERRCOUNT
	190	DEFERROR
	191	DEFLOB
	192	DEFPROPAGATOR
	193	DEFSCHEDULE
	194	DEFTRAN
	195	DEFTRANDEST
	196	DEPTH
	197	DEVELOPMENT_SERVICE_HOME
	198	DEVELOPMENT_SERVICE_HOME_LOGIN
	199	DEVELOPMENT_SERVICE_SIGNUP
	200	DICT
	201	DICTIONARY
	202	DICT_COLUMNS
	203	DIFFERENCE
	204	DIMENSION
	205	DISJOINT
	206	DISTANCE
	207	DM_CENTROIDS
	208	DM_CL_BUILD
	209	DM_SVM_APPLY
	210	DM_SVM_BUILD
	211	DRVODM
	212	DS_SQL_WORKSHOP
	213	DUAL
	214	ENDPOINT
	215	ENVELOPE
	216	EQUALS
	217	EQUALS_PATH
	218	EXPLAINMVARRAYTYPE
	219	EXPLAINMVMESSAGE
	220	EXTERIORRING
	221	F
	222	FLASHBACK_TRANSACTION_QUERY
	223	FTPURITYPE
	224	GEOMETRY
	225	GEOMETRYCOLLECTION
	226	GEOMETRYN
	227	GEOMETRYTYPE
	228	GLOBAL_CONTEXT
	229	GLOBAL_NAME
	230	GV$ACCESS
	231	GV$ACTIVE_INSTANCES
	232	GV$ACTIVE_SERVICES
	233	GV$ACTIVE_SESSION_HISTORY
	234	GV$ACTIVE_SESS_POOL_MTH
	235	GV$ADVISOR_PROGRESS
	236	GV$ALERT_TYPES
	237	GV$AQ
	238	GV$AQ1
	239	GV$ARCHIVE
	240	GV$ARCHIVED_LOG
	241	GV$ARCHIVE_DEST
	242	GV$ARCHIVE_DEST_STATUS
	243	GV$ARCHIVE_GAP
	244	GV$ARCHIVE_PROCESSES
	245	GV$ASM_ALIAS
	246	GV$ASM_CLIENT
	247	GV$ASM_DISK
	248	GV$ASM_DISKGROUP
	249	GV$ASM_DISKGROUP_STAT
	250	GV$ASM_DISK_STAT
	251	GV$ASM_FILE
	252	GV$ASM_OPERATION
	253	GV$ASM_TEMPLATE
	254	GV$AW_AGGREGATE_OP
	255	GV$AW_ALLOCATE_OP
	256	GV$AW_CALC
	257	GV$AW_LONGOPS
	258	GV$AW_OLAP
	259	GV$AW_SESSION_INFO
	260	GV$BACKUP
	261	GV$BACKUP_ASYNC_IO
	262	GV$BACKUP_CORRUPTION
	263	GV$BACKUP_DATAFILE
	264	GV$BACKUP_DEVICE
	265	GV$BACKUP_PIECE
	266	GV$BACKUP_REDOLOG
	267	GV$BACKUP_SET
	268	GV$BACKUP_SPFILE
	269	GV$BACKUP_SYNC_IO
	270	GV$BGPROCESS
	271	GV$BH
	272	GV$BLOCKING_QUIESCE
	273	GV$BSP
	274	GV$BUFFERED_PUBLISHERS
	275	GV$BUFFERED_QUEUES
	276	GV$BUFFERED_SUBSCRIBERS
	277	GV$BUFFER_POOL
	278	GV$BUFFER_POOL_STATISTICS
	279	GV$CIRCUIT
	280	GV$CLASS_CACHE_TRANSFER
	281	GV$CLASS_PING
	282	GV$CLIENT_STATS
	283	GV$CLUSTER_INTERCONNECTS
	284	GV$CONFIGURED_INTERCONNECTS
	285	GV$CONTEXT
	286	GV$CONTROLFILE
	287	GV$CONTROLFILE_RECORD_SECTION
	288	GV$COPY_CORRUPTION
	289	GV$CR_BLOCK_SERVER
	290	GV$CURRENT_BLOCK_SERVER
	291	GV$DATABASE
	292	GV$DATABASE_BLOCK_CORRUPTION
	293	GV$DATABASE_INCARNATION
	294	GV$DATAFILE
	295	GV$DATAFILE_COPY
	296	GV$DATAFILE_HEADER
	297	GV$DATAGUARD_CONFIG
	298	GV$DATAGUARD_STATUS
	299	GV$DATAPUMP_JOB
	300	GV$DATAPUMP_SESSION
	301	GV$DBFILE
	302	GV$DBLINK
	303	GV$DB_CACHE_ADVICE
	304	GV$DB_OBJECT_CACHE
	305	GV$DB_PIPES
	306	GV$DELETED_OBJECT
	307	GV$DISPATCHER
	308	GV$DISPATCHER_CONFIG
	309	GV$DISPATCHER_RATE
	310	GV$DLM_ALL_LOCKS
	311	GV$DLM_CONVERT_LOCAL
	312	GV$DLM_CONVERT_REMOTE
	313	GV$DLM_LATCH
	314	GV$DLM_LOCKS
	315	GV$DLM_MISC
	316	GV$DLM_RESS
	317	GV$DLM_TRAFFIC_CONTROLLER
	318	GV$ENABLEDPRIVS
	319	GV$ENQUEUE_LOCK
	320	GV$ENQUEUE_STAT
	321	GV$ENQUEUE_STATISTICS
	322	GV$EVENTMETRIC
	323	GV$EVENT_HISTOGRAM
	324	GV$EVENT_NAME
	325	GV$EXECUTION
	326	GV$FAST_START_SERVERS
	327	GV$FAST_START_TRANSACTIONS
	328	GV$FILEMETRIC
	329	GV$FILEMETRIC_HISTORY
	330	GV$FILESPACE_USAGE
	331	GV$FILESTAT
	332	GV$FILE_CACHE_TRANSFER
	333	GV$FILE_HISTOGRAM
	334	GV$FILE_PING
	335	GV$FIXED_VIEW_DEFINITION
	336	GV$FLASHBACK_DATABASE_LOG
	337	GV$FLASHBACK_DATABASE_LOGFILE
	338	GV$FLASHBACK_DATABASE_STAT
	339	GV$GCSHVMASTER_INFO
	340	GV$GCSPFMASTER_INFO
	341	GV$GC_ELEMENT
	342	GV$GC_ELEMENTS_WITH_COLLISIONS
	343	GV$GES_BLOCKING_ENQUEUE
	344	GV$GES_ENQUEUE
	345	GV$GLOBALCONTEXT
	346	GV$GLOBAL_BLOCKED_LOCKS
	347	GV$GLOBAL_TRANSACTION
	348	GV$HS_AGENT
	349	GV$HS_PARAMETER
	350	GV$HS_SESSION
	351	GV$HVMASTER_INFO
	352	GV$INDEXED_FIXED_COLUMN
	353	GV$INSTANCE
	354	GV$INSTANCE_CACHE_TRANSFER
	355	GV$INSTANCE_LOG_GROUP
	356	GV$INSTANCE_RECOVERY
	357	GV$JAVAPOOL
	358	GV$JAVA_LIBRARY_CACHE_MEMORY
	359	GV$JAVA_POOL_ADVICE
	360	GV$LATCH
	361	GV$LATCHHOLDER
	362	GV$LATCHNAME
	363	GV$LATCH_CHILDREN
	364	GV$LATCH_MISSES
	365	GV$LATCH_PARENT
	366	GV$LIBRARYCACHE
	367	GV$LIBRARY_CACHE_MEMORY
	368	GV$LICENSE
	369	GV$LOADISTAT
	370	GV$LOADPSTAT
	371	GV$LOCK
	372	GV$LOCKED_OBJECT
	373	GV$LOCKS_WITH_COLLISIONS
	374	GV$LOCK_ACTIVITY
	375	GV$LOCK_ELEMENT
	376	GV$LOCK_TYPE
	377	GV$LOG
	378	GV$LOGFILE
	379	GV$LOGHIST
	380	GV$LOGMNR_CALLBACK
	381	GV$LOGMNR_CONTENTS
	382	GV$LOGMNR_DICTIONARY
	383	GV$LOGMNR_DICTIONARY_LOAD
	384	GV$LOGMNR_LATCH
	385	GV$LOGMNR_LOGFILE
	386	GV$LOGMNR_LOGS
	387	GV$LOGMNR_PARAMETERS
	388	GV$LOGMNR_PROCESS
	389	GV$LOGMNR_REGION
	390	GV$LOGMNR_SESSION
	391	GV$LOGMNR_STATS
	392	GV$LOGMNR_TRANSACTION
	393	GV$LOGSTDBY
	394	GV$LOGSTDBY_PROCESS
	395	GV$LOGSTDBY_PROGRESS
	396	GV$LOGSTDBY_STATE
	397	GV$LOGSTDBY_STATS
	398	GV$LOGSTDBY_TRANSACTION
	399	GV$LOG_HISTORY
	400	GV$MANAGED_STANDBY
	401	GV$MAP_COMP_LIST
	402	GV$MAP_ELEMENT
	403	GV$MAP_EXT_ELEMENT
	404	GV$MAP_FILE
	405	GV$MAP_FILE_EXTENT
	406	GV$MAP_FILE_IO_STACK
	407	GV$MAP_LIBRARY
	408	GV$MAP_SUBELEMENT
	409	GV$MAX_ACTIVE_SESS_TARGET_MTH
	410	GV$METRIC
	411	GV$METRICGROUP
	412	GV$METRICNAME
	413	GV$METRIC_HISTORY
	414	GV$MTTR_TARGET_ADVICE
	415	GV$MUTEX_SLEEP
	416	GV$MUTEX_SLEEP_HISTORY
	417	GV$MVREFRESH
	418	GV$MYSTAT
	419	GV$NLS_PARAMETERS
	420	GV$NLS_VALID_VALUES
	421	GV$OBJECT_DEPENDENCY
	422	GV$OBSOLETE_PARAMETER
	423	GV$OFFLINE_RANGE
	424	GV$OPEN_CURSOR
	425	GV$OPTION
	426	GV$OSSTAT
	427	GV$PARALLEL_DEGREE_LIMIT_MTH
	428	GV$PARAMETER
	429	GV$PARAMETER2
	430	GV$PARAMETER_VALID_VALUES
	431	GV$PGASTAT
	432	GV$PGA_TARGET_ADVICE
	433	GV$PGA_TARGET_ADVICE_HISTOGRAM
	434	GV$PQ_SESSTAT
	435	GV$PQ_SLAVE
	436	GV$PQ_SYSSTAT
	437	GV$PQ_TQSTAT
	438	GV$PROCESS
	439	GV$PROCESS_MEMORY
	440	GV$PROCESS_MEMORY_DETAIL
	441	GV$PROCESS_MEMORY_DETAIL_PROG
	442	GV$PROPAGATION_RECEIVER
	443	GV$PROPAGATION_SENDER
	444	GV$PROXY_ARCHIVEDLOG
	445	GV$PROXY_DATAFILE
	446	GV$PWFILE_USERS
	447	GV$PX_BUFFER_ADVICE
	448	GV$PX_PROCESS
	449	GV$PX_PROCESS_SYSSTAT
	450	GV$PX_SESSION
	451	GV$PX_SESSTAT
	452	GV$QUEUE
	453	GV$QUEUEING_MTH
	454	GV$RECOVERY_FILE_STATUS
	455	GV$RECOVERY_LOG
	456	GV$RECOVERY_PROGRESS
	457	GV$RECOVERY_STATUS
	458	GV$RECOVER_FILE
	459	GV$REPLPROP
	460	GV$REPLQUEUE
	461	GV$REQDIST
	462	GV$RESERVED_WORDS
	463	GV$RESOURCE
	464	GV$RESOURCE_LIMIT
	465	GV$RESTORE_POINT
	466	GV$RESUMABLE
	467	GV$RFS_THREAD
	468	GV$RMAN_CONFIGURATION
	469	GV$RMAN_OUTPUT
	470	GV$ROLLSTAT
	471	GV$ROWCACHE
	472	GV$ROWCACHE_PARENT
	473	GV$ROWCACHE_SUBORDINATE
	474	GV$RSRC_CONSUMER_GROUP
	475	GV$RSRC_CONSUMER_GROUP_CPU_MTH
	476	GV$RSRC_CONS_GROUP_HISTORY
	477	GV$RSRC_PLAN
	478	GV$RSRC_PLAN_CPU_MTH
	479	GV$RSRC_PLAN_HISTORY
	480	GV$RSRC_SESSION_INFO
	481	GV$RULE
	482	GV$RULE_SET
	483	GV$RULE_SET_AGGREGATE_STATS
	484	GV$SCHEDULER_RUNNING_JOBS
	485	GV$SEGMENT_STATISTICS
	486	GV$SEGSTAT
	487	GV$SEGSTAT_NAME
	488	GV$SERVICEMETRIC
	489	GV$SERVICEMETRIC_HISTORY
	490	GV$SERVICES
	491	GV$SERVICE_EVENT
	492	GV$SERVICE_STATS
	493	GV$SERVICE_WAIT_CLASS
	494	GV$SERV_MOD_ACT_STATS
	495	GV$SESSION
	496	GV$SESSION_CONNECT_INFO
	497	GV$SESSION_CURSOR_CACHE
	498	GV$SESSION_EVENT
	499	GV$SESSION_LONGOPS
	500	GV$SESSION_OBJECT_CACHE
	501	GV$SESSION_WAIT
	502	GV$SESSION_WAIT_CLASS
	503	GV$SESSION_WAIT_HISTORY
	504	GV$SESSMETRIC
	505	GV$SESSTAT
	506	GV$SESS_IO
	507	GV$SESS_TIME_MODEL
	508	GV$SES_OPTIMIZER_ENV
	509	GV$SGA
	510	GV$SGAINFO
	511	GV$SGASTAT
	512	GV$SGA_CURRENT_RESIZE_OPS
	513	GV$SGA_DYNAMIC_COMPONENTS
	514	GV$SGA_DYNAMIC_FREE_MEMORY
	515	GV$SGA_RESIZE_OPS
	516	GV$SGA_TARGET_ADVICE
	517	GV$SHARED_POOL_ADVICE
	518	GV$SHARED_POOL_RESERVED
	519	GV$SHARED_SERVER
	520	GV$SHARED_SERVER_MONITOR
	521	GV$SORT_SEGMENT
	522	GV$SORT_USAGE
	523	GV$SPPARAMETER
	524	GV$SQL
	525	GV$SQLAREA
	526	GV$SQLAREA_PLAN_HASH
	527	GV$SQLSTATS
	528	GV$SQLTEXT
	529	GV$SQLTEXT_WITH_NEWLINES
	530	GV$SQL_BIND_CAPTURE
	531	GV$SQL_BIND_DATA
	532	GV$SQL_BIND_METADATA
	533	GV$SQL_CURSOR
	534	GV$SQL_JOIN_FILTER
	535	GV$SQL_OPTIMIZER_ENV
	536	GV$SQL_PLAN
	537	GV$SQL_PLAN_STATISTICS
	538	GV$SQL_PLAN_STATISTICS_ALL
	539	GV$SQL_REDIRECTION
	540	GV$SQL_SHARED_CURSOR
	541	GV$SQL_SHARED_MEMORY
	542	GV$SQL_WORKAREA
	543	GV$SQL_WORKAREA_ACTIVE
	544	GV$SQL_WORKAREA_HISTOGRAM
	545	GV$STANDBY_APPLY_SNAPSHOT
	546	GV$STANDBY_LOG
	547	GV$STATISTICS_LEVEL
	548	GV$STATNAME
	549	GV$STREAMS_APPLY_COORDINATOR
	550	GV$STREAMS_APPLY_READER
	551	GV$STREAMS_APPLY_SERVER
	552	GV$STREAMS_CAPTURE
	553	GV$STREAMS_POOL_ADVICE
	554	GV$STREAMS_TRANSACTION
	555	GV$SUBCACHE
	556	GV$SYSAUX_OCCUPANTS
	557	GV$SYSMETRIC
	558	GV$SYSMETRIC_HISTORY
	559	GV$SYSMETRIC_SUMMARY
	560	GV$SYSSTAT
	561	GV$SYSTEM_CURSOR_CACHE
	562	GV$SYSTEM_EVENT
	563	GV$SYSTEM_PARAMETER
	564	GV$SYSTEM_PARAMETER2
	565	GV$SYSTEM_WAIT_CLASS
	566	GV$SYS_OPTIMIZER_ENV
	567	GV$SYS_TIME_MODEL
	568	GV$TEMPFILE
	569	GV$TEMPORARY_LOBS
	570	GV$TEMPSEG_USAGE
	571	GV$TEMPSTAT
	572	GV$TEMP_CACHE_TRANSFER
	573	GV$TEMP_EXTENT_MAP
	574	GV$TEMP_EXTENT_POOL
	575	GV$TEMP_HISTOGRAM
	576	GV$TEMP_PING
	577	GV$TEMP_SPACE_HEADER
	578	GV$THREAD
	579	GV$THRESHOLD_TYPES
	580	GV$TIMER
	581	GV$TIMEZONE_FILE
	582	GV$TIMEZONE_NAMES
	583	GV$TRANSACTION
	584	GV$TRANSACTION_ENQUEUE
	585	GV$TSM_SESSIONS
	586	GV$TYPE_SIZE
	587	GV$UNDOSTAT
	588	GV$VERSION
	589	GV$VPD_POLICY
	590	GV$WAITCLASSMETRIC
	591	GV$WAITCLASSMETRIC_HISTORY
	592	GV$WAITSTAT
	593	GV$WALLET
	594	GV$XML_AUDIT_TRAIL
	595	GV$_LOCK
	596	HHAND
	597	HHBYTELEN
	598	HHCBIT
	599	HHCELLBNDRY
	600	HHCELLSIZE
	601	HHCLDATE
	602	HHCOLLAPSE
	603	HHCOMMONCODE
	604	HHCOMPARE
	605	HHCOMPOSE
	606	HHDECODE
	607	HHDISTANCE
	608	HHENCODE
	609	HHENCODE_BYLEVEL
	610	HHGBIT
	611	HHGETCID
	612	HHGROUP
	613	HHGTBIT
	614	HHGTYPE
	615	HHIDLPART
	616	HHIDPART
	617	HHINCRLEV
	618	HHJLDATE
	619	HHLENGTH
	620	HHLEVELS
	621	HHMATCH
	622	HHMAXCODE
	623	HHNCOMPARE
	624	HHNDIM
	625	HHOR
	626	HHORDER
	627	HHPRECISION
	628	HHSBIT
	629	HHSETCID
	630	HHSTBIT
	631	HHSTYPE
	632	HHSUBDIVIDE
	633	HHSUBSTR
	634	HHXOR
	635	HS_ALL_CAPS
	636	HS_ALL_DD
	637	HS_ALL_INITS
	638	HS_BASE_CAPS
	639	HS_BASE_DD
	640	HS_CLASS_CAPS
	641	HS_CLASS_DD
	642	HS_CLASS_INIT
	643	HS_FDS_CLASS
	644	HS_FDS_CLASS_DATE
	645	HS_FDS_INST
	646	HS_INST_CAPS
	647	HS_INST_DD
	648	HS_INST_INIT
	649	HTF
	650	HTMLDB
	651	HTMLDB_ACTIVITY_LOG
	652	HTMLDB_APPLICATION
	653	HTMLDB_APPLICATION_FILES
	654	HTMLDB_APPLICATION_GLOBAL
	655	HTMLDB_COLLECTION
	656	HTMLDB_COLLECTIONS
	657	HTMLDB_CUSTOM_AUTH
	658	HTMLDB_ITEM
	659	HTMLDB_LANG
	660	HTMLDB_LDAP
	661	HTMLDB_LOGIN
	662	HTMLDB_MAIL
	663	HTMLDB_MAIL_LOG
	664	HTMLDB_MAIL_QUEUE
	665	HTMLDB_PLSQL_JOB
	666	HTMLDB_PLSQL_JOBS
	667	HTMLDB_SYSTEM
	668	HTMLDB_UTIL
	669	HTP
	670	HTTPURITYPE
	671	IND
	672	INDEX_HISTOGRAM
	673	INDEX_STATS
	674	INTERIORRINGN
	675	INTERSECTION
	676	INTERSECTS
	677	ISCLOSED
	678	ISEMPTY
	679	ISRING
	680	ISSIMPLE
	681	KU$_AUDDEF_T
	682	KU$_AUDIT_DEFAULT_LIST_T
	683	KU$_AUDIT_LIST_T
	684	KU$_AUDOBJ_T
	685	KU$_CHUNK_LIST_T
	686	KU$_CHUNK_T
	687	KU$_DDL
	688	KU$_DDLS
	689	KU$_DUMPFILE
	690	KU$_DUMPFILE1010
	691	KU$_DUMPFILE1020
	692	KU$_DUMPFILESET
	693	KU$_DUMPFILESET1010
	694	KU$_DUMPFILESET1020
	695	KU$_DUMPFILE_INFO
	696	KU$_DUMPFILE_ITEM
	697	KU$_ERRORLINE
	698	KU$_ERRORLINES
	699	KU$_JAVA_T
	700	KU$_JOBDESC
	701	KU$_JOBDESC1010
	702	KU$_JOBDESC1020
	703	KU$_JOBSTATUS
	704	KU$_JOBSTATUS1010
	705	KU$_JOBSTATUS1020
	706	KU$_LOGENTRY
	707	KU$_LOGENTRY1010
	708	KU$_LOGENTRY1020
	709	KU$_LOGLINE
	710	KU$_LOGLINE1010
	711	KU$_LOGLINE1020
	712	KU$_MULTI_DDL
	713	KU$_MULTI_DDLS
	714	KU$_OBJNUMPAIR
	715	KU$_OBJNUMPAIRLIST
	716	KU$_OBJNUMSET
	717	KU$_PARAMVALUE
	718	KU$_PARAMVALUE1010
	719	KU$_PARAMVALUE1020
	720	KU$_PARAMVALUES
	721	KU$_PARAMVALUES1010
	722	KU$_PARAMVALUES1020
	723	KU$_PARSED_ITEM
	724	KU$_PARSED_ITEMS
	725	KU$_PROCOBJ_LINE
	726	KU$_PROCOBJ_LINES
	727	KU$_PROCOBJ_LOC
	728	KU$_PROCOBJ_LOCS
	729	KU$_SOURCE_LIST_T
	730	KU$_SOURCE_T
	731	KU$_STATUS
	732	KU$_STATUS1010
	733	KU$_STATUS1020
	734	KU$_SUBMITRESULT
	735	KU$_SUBMITRESULTS
	736	KU$_TACTION_LIST_T
	737	KU$_TACTION_T
	738	KU$_VCNT
	739	KU$_WORKERSTATUS
	740	KU$_WORKERSTATUS1010
	741	KU$_WORKERSTATUS1020
	742	KU$_WORKERSTATUSLIST
	743	KU$_WORKERSTATUSLIST1010
	744	KU$_WORKERSTATUSLIST1020
	745	KUPCC
	746	LINESTRING
	747	LINESTRINGFROMTEXT
	748	LINESTRINGFROMWKB
	749	LOADER_COL_FLAGS
	750	LOADER_COL_INFO
	751	LOADER_COL_TYPE
	752	LOADER_CONSTRAINT_INFO
	753	LOADER_DIR_OBJS
	754	LOADER_FILE_TS
	755	LOADER_FULL_ATTR_NAME
	756	LOADER_INTCOL_INFO
	757	LOADER_LOB_FLAGS
	758	LOADER_NESTED_VARRAYS
	759	LOADER_OID_INFO
	760	LOADER_PARAM_INFO
	761	LOADER_PART_INFO
	762	LOADER_REF_INFO
	763	LOADER_SKIP_UNUSABLE_INDEXES
	764	LOADER_TAB_INFO
	765	LOADER_TRIGGER_INFO
	766	LOCATOR_WITHIN_DISTANCE
	767	MAP_OBJECT
	768	MATCHES
	769	MATCH_SCORE
	770	MD
	771	MD_LRS
	772	MULTICURVE
	773	MULTILINESTRING
	774	MULTILINESTRINGFROMTEXT
	775	MULTILINESTRINGFROMWKB
	776	MULTIPOINT
	777	MULTIPOLYGON
	778	MULTIPOLYGONFROMTEXT
	779	MULTIPOLYGONFROMWKB
	780	MULTISURFACE
	781	MY_SDO_INDEX_METADATA
	782	NLS_DATABASE_PARAMETERS
	783	NLS_INSTANCE_PARAMETERS
	784	NLS_SESSION_PARAMETERS
	785	NUMGEOMETRIES
	786	NUMINTERIORRINGS
	787	NUMPOINTS
	788	NV
	789	OBJ
	790	ODCICONST
	791	ODM_UTIL
	792	OGC_CONTAINS
	793	OGC_LENGTH
	794	OGC_UNION
	795	OGIS_GEOMETRY_COLUMNS
	796	OGIS_SPATIAL_REFERENCE_SYSTEMS
	797	OL$
	798	OL$HINTS
	799	OL$NODES
	800	OLAP_BOOL_SRF
	801	OLAP_CONDITION
	802	OLAP_DATE_SRF
	803	OLAP_EXPRESSION
	804	OLAP_EXPRESSION_BOOL
	805	OLAP_EXPRESSION_DATE
	806	OLAP_EXPRESSION_TEXT
	807	OLAP_NUMBER_SRF
	808	OLAP_SRF_T
	809	OLAP_TEXT_SRF
	810	ORA_CLIENT_IP_ADDRESS
	811	ORA_DATABASE_NAME
	812	ORA_DES_ENCRYPTED_PASSWORD
	813	ORA_DICT_OBJ_NAME
	814	ORA_DICT_OBJ_NAME_LIST
	815	ORA_DICT_OBJ_OWNER
	816	ORA_DICT_OBJ_OWNER_LIST
	817	ORA_DICT_OBJ_TYPE
	818	ORA_DM_TREE_NODES
	819	ORA_FI_DECISION_TREE_HORIZ
	820	ORA_GRANTEE
	821	ORA_INSTANCE_NUM
	822	ORA_IS_ALTER_COLUMN
	823	ORA_IS_DROP_COLUMN
	824	ORA_IS_SERVERERROR
	825	ORA_KGLR7_DB_LINKS
	826	ORA_KGLR7_DEPENDENCIES
	827	ORA_KGLR7_IDL_CHAR
	828	ORA_KGLR7_IDL_SB4
	829	ORA_KGLR7_IDL_UB1
	830	ORA_KGLR7_IDL_UB2
	831	ORA_LOGIN_USER
	832	ORA_PARTITION_POS
	833	ORA_PRIVILEGE_LIST
	834	ORA_REVOKEE
	835	ORA_SERVER_ERROR
	836	ORA_SERVER_ERROR_DEPTH
	837	ORA_SERVER_ERROR_MSG
	838	ORA_SERVER_ERROR_NUM_PARAMS
	839	ORA_SERVER_ERROR_PARAM
	840	ORA_SPACE_ERROR_INFO
	841	ORA_SQL_TXT
	842	ORA_SYSEVENT
	843	ORA_WITH_GRANT_OPTION
	844	OUTLINE
	845	OUTLN_PKG
	846	OVERLAP
	847	OWA
	848	OWA_CACHE
	849	OWA_COOKIE
	850	OWA_CUSTOM
	851	OWA_GLOBAL
	852	OWA_IMAGE
	853	OWA_INIT
	854	OWA_MATCH
	855	OWA_OPT_LOCK
	856	OWA_PATTERN
	857	OWA_SEC
	858	OWA_TEXT
	859	OWA_UTIL
	860	P
	861	PATH
	862	PATH_VIEW
	863	PBSDE
	864	PLITBLM
	865	POINT
	866	POINTFROMTEXT
	867	POINTFROMWKB
	868	POINTN
	869	POINTONSURFACE
	870	POLYGON
	871	POLYGONFROMTEXT
	872	POLYGONFROMWKB
	873	PRODUCT_COMPONENT_VERSION
	874	PRODUCT_PROFILE
	875	PRODUCT_USER_PROFILE
	876	PROXY_ROLES
	877	PROXY_USERS
	878	PROXY_USERS_AND_ROLES
	879	PUBLIC_DEPENDENCY
	880	QUEUE_PRIVILEGES
	881	RECYCLEBIN
	882	RELATE
	883	REPCAT_REPCOLUMN_BASE
	884	RESOURCE_COST
	885	RESOURCE_VIEW
	886	REWRITEARRAYTYPE
	887	REWRITEMESSAGE
	888	ROLE_ROLE_PRIVS
	889	ROLE_SYS_PRIVS
	890	ROLE_TAB_PRIVS
	891	RTREEJOINFUNC
	892	SCHEMA_EXPORT_OBJECTS
	893	SCN_TO_TIMESTAMP
	894	SCORE
	895	SDO
	896	SDOAGGRTYPE
	897	SDO_3GL
	898	SDO_ADDR_ARRAY
	899	SDO_ADMIN
	900	SDO_AGGR_CENTROID
	901	SDO_AGGR_CONCAT_LINES
	902	SDO_AGGR_CONVEXHULL
	903	SDO_AGGR_LRS_CONCAT
	904	SDO_AGGR_LRS_CONCAT_3D
	905	SDO_AGGR_MBR
	906	SDO_AGGR_UNION
	907	SDO_ANGLE_UNITS
	908	SDO_ANYINTERACT
	909	SDO_AREA_UNITS
	910	SDO_AVAILABLE_ELEM_OPS
	911	SDO_AVAILABLE_NON_ELEM_OPS
	912	SDO_AVAILABLE_OPS
	913	SDO_CATALOG
	914	SDO_CONTAINS
	915	SDO_COORD_AXES
	916	SDO_COORD_AXIS_NAMES
	917	SDO_COORD_OPS
	918	SDO_COORD_OP_METHODS
	919	SDO_COORD_OP_PARAMS
	920	SDO_COORD_OP_PARAM_USE
	921	SDO_COORD_OP_PARAM_VALS
	922	SDO_COORD_OP_PATHS
	923	SDO_COORD_REF_SYS
	924	SDO_COORD_REF_SYSTEM
	925	SDO_COORD_SYS
	926	SDO_COVEREDBY
	927	SDO_COVERS
	928	SDO_CRS_COMPOUND
	929	SDO_CRS_ENGINEERING
	930	SDO_CRS_GEOCENTRIC
	931	SDO_CRS_GEOGRAPHIC2D
	932	SDO_CRS_GEOGRAPHIC3D
	933	SDO_CRS_PROJECTED
	934	SDO_CRS_VERTICAL
	935	SDO_CS
	936	SDO_DATUMS
	937	SDO_DATUMS_OLD_FORMAT
	938	SDO_DATUMS_OLD_SNAPSHOT
	939	SDO_DATUM_ENGINEERING
	940	SDO_DATUM_GEODETIC
	941	SDO_DATUM_VERTICAL
	942	SDO_DIM_ARRAY
	943	SDO_DIM_ELEMENT
	944	SDO_DIST_UNITS
	945	SDO_EDGE_ARRAY
	946	SDO_ELEM_INFO_ARRAY
	947	SDO_ELLIPSOIDS
	948	SDO_ELLIPSOIDS_OLD_FORMAT
	949	SDO_ELLIPSOIDS_OLD_SNAPSHOT
	950	SDO_EQUAL
	951	SDO_FILTER
	952	SDO_GEOM
	953	SDO_GEOMETRY
	954	SDO_GEO_ADDR
	955	SDO_INDEX_METADATA
	956	SDO_INSIDE
	957	SDO_JOIN
	958	SDO_KEYWORDARRAY
	959	SDO_LIST_TYPE
	960	SDO_LRS
	961	SDO_MBR
	962	SDO_MIGRATE
	963	SDO_NN
	964	SDO_NN_DISTANCE
	965	SDO_NUMBER_ARRAY
	966	SDO_ON
	967	SDO_ORDINATE_ARRAY
	968	SDO_OVERLAPBDYDISJOINT
	969	SDO_OVERLAPBDYINTERSECT
	970	SDO_OVERLAPS
	971	SDO_POINT_TYPE
	972	SDO_PREFERRED_OPS_SYSTEM
	973	SDO_PREFERRED_OPS_USER
	974	SDO_PRIDX
	975	SDO_PRIME_MERIDIANS
	976	SDO_PROJECTIONS_OLD_FORMAT
	977	SDO_PROJECTIONS_OLD_SNAPSHOT
	978	SDO_REGAGGR
	979	SDO_REGAGGRSET
	980	SDO_REGION
	981	SDO_REGIONSET
	982	SDO_RELATE
	983	SDO_RELATE_MASK
	984	SDO_ROWIDPAIR
	985	SDO_ROWIDSET
	986	SDO_RTREE_ADMIN
	987	SDO_RTREE_FILTER
	988	SDO_RTREE_RELATE
	989	SDO_SRID_CHAIN
	990	SDO_SRID_LIST
	991	SDO_STRING_ARRAY
	992	SDO_TFM_CHAIN
	993	SDO_TGL_OBJECT
	994	SDO_TGL_OBJECT_ARRAY
	995	SDO_TOPO_DATA$
	996	SDO_TOPO_GEOMETRY
	997	SDO_TOPO_GEOMETRY_LAYER
	998	SDO_TOPO_GEOMETRY_LAYER_ARRAY
	999	SDO_TOPO_NSTD_TBL
	1000	SDO_TOPO_OBJECT
	1001	SDO_TOPO_OBJECT_ARRAY
	1002	SDO_TOPO_TRANSACT_DATA$
	1003	SDO_TOUCH
	1004	SDO_TRANSIENT_RULE
	1005	SDO_TRANSIENT_RULE_SET
	1006	SDO_TUNE
	1007	SDO_TXN_IDX_DELETES
	1008	SDO_TXN_IDX_EXP_UPD_RGN
	1009	SDO_TXN_IDX_INSERTS
	1010	SDO_UNITS_OF_MEASURE
	1011	SDO_UTIL
	1012	SDO_VERSION
	1013	SDO_VPOINT_TYPE
	1014	SDO_WITHIN_DISTANCE
	1015	SEQ
	1016	SESSION_CONTEXT
	1017	SESSION_PRIVS
	1018	SESSION_ROLES
	1019	SM$VERSION
	1020	SPATIAL_INDEX
	1021	SQLPROF_ATTR
	1022	SQLSET
	1023	SQLSET_ROW
	1024	SQL_BIND
	1025	SQL_BINDS
	1026	SQL_BIND_SET
	1027	SQL_OBJECTS
	1028	SQL_PLAN_ROW_TYPE
	1029	SQL_PLAN_STAT_ROW_TYPE
	1030	SRID
	1031	STARTPOINT
	1032	STMT_AUDIT_OPTION_MAP
	1033	SURFACE
	1034	SYMMETRICDIFFERENCE
	1035	SYN
	1036	SYSTEM_PRIVILEGE_MAP
	1037	SYS_IXQAGG
	1038	SYS_NT_COLLECT
	1039	SYS_XMLAGG
	1040	TEMP$LOB
	1041	TFM_PLAN
	1042	TIMESTAMP_TO_SCN
	1043	TMP_COORD_OPS
	1044	TOUCH
	1045	TRUSTED_SERVERS
	1046	UNDER_PATH
	1047	URIFACTORY
	1048	URITYPE
	1049	USER_
	1050	UTL_
	1051	V
	1052	V$
	1053	WITHIN
	1054	WPG_DOCLOAD
	1055	WWV_
	1056	X
	1057	XDB$STRING_LIST_T
	1058	XDBURITYPE
	1059	XDB_PVTRIG_PKG
	1060	XDB_RVTRIG_PKG
	1061	XMLAGG
	1062	XMLDOM
	1063	XMLFORMAT
	1064	XMLPARSER
	1065	XMLSEQUENCE
	1066	XMLSEQUENCETYPE
	1067	XMLTYPE
	1068	XQSEQUENCE
	1069	XSLPROCESSOR
	1070	Y
	1071	Z
	1072	_ALL_INSTANTIATION_DDL
	1073	_ALL_REPEXTENSIONS
	1074	_ALL_REPSITES_NEW
	1075	_ALL_SQLSET_STATEMENTS_ONLY
	1076	_ALL_SQLSET_STATEMENTS_PHV
	1077	_ALL_SQLSET_STATISTICS_ONLY
	1078	SCHEDULER$_JOBSUFFIX_S
	1079	AUDIT_ACTIONS
	1080	DUAL
	1081	IMPDP_STATS
	1082	KU$NOEXP_TAB
	1083	ODCI_SECOBJ$
	1084	ODCI_WARNINGS$
	1085	PSTUBTBL
	1086	STMT_AUDIT_OPTION_MAP
	1087	SYSTEM_PRIVILEGE_MAP
	1088	WRI$_ADV_ASA_RECO_DATA
	1089	DEF$_TEMP$LOB
	1090	HELP
	1091	OL$
	1092	OL$HINTS
	1093	OL$NODES
	1094	ALL_
	1095	CATALOG
	1096	COL
	1097	COLUMN_PRIVILEGES
	1098	DATABASE_COMPATIBLE_LEVEL
	1099	DATABASE_EXPORT_OBJECTS
	1100	DATABASE_PROPERTIES
	1101	DATAPUMP_DDL_TRANSFORM_PARAMS
	1102	DATAPUMP_OBJECT_CONNECT
	1103	DATAPUMP_PATHMAP
	1104	DATAPUMP_PATHS
	1105	DATAPUMP_REMAP_OBJECTS
	1106	DBA_AUTO_SEGADV_CTL
	1107	DBA_AUTO_SEGADV_SUMMARY
	1108	DEFERRCOUNT
	1109	DICTIONARY
	1110	DICT_COLUMNS
	1111	EXPCOMPRESSEDPART
	1112	EXPCOMPRESSEDSUB
	1113	EXPCOMPRESSEDTAB
	1114	EXPEXEMPT
	1115	EXPGETENCCOLNAM
	1116	EXPTABSUBPART
	1117	EXPTABSUBPARTDATA_VIEW
	1118	EXPTABSUBPARTLOBFRAG
	1119	EXPTABSUBPARTLOB_VIEW
	1120	EXU102XTYPU
	1121	EXU10ADEFPSWITCHES
	1122	EXU10AOBJSWITCH
	1123	EXU10ASCU
	1124	EXU10CCLO
	1125	EXU10CCLU
	1126	EXU10COEU
	1127	EXU10DEFPSWITCHES
	1128	EXU10DOSO
	1129	EXU10IND_BASE
	1130	EXU10LNKU
	1131	EXU10MVL
	1132	EXU10MVLU
	1133	EXU10OBJSWITCH
	1134	EXU10R2DEFPSWITCHES
	1135	EXU10R2OBJSWITCH
	1136	EXU10SNAPLU
	1137	EXU10SNAPU
	1138	EXU10TABSU
	1139	EXU10TABU
	1140	EXU816MAXSQV
	1141	EXU816TGRU
	1142	EXU81ACTIONOBJ
	1143	EXU81ACTIONPKG
	1144	EXU81ASSOC
	1145	EXU81CSC
	1146	EXU81DOIU
	1147	EXU81IND
	1148	EXU81IND_BASE
	1149	EXU81ITYU
	1150	EXU81IXCPU
	1151	EXU81IXSPU
	1152	EXU81JAV
	1153	EXU81JAVT
	1154	EXU81LBCPU
	1155	EXU81LBPU
	1156	EXU81LBSPU
	1157	EXU81NOS
	1158	EXU81OBJECTPKG
	1159	EXU81OPRU
	1160	EXU81PLBU
	1161	EXU81PROCOBJ
	1162	EXU81PROCOBJINSTANCE
	1163	EXU81RGCU
	1164	EXU81RGSU
	1165	EXU81RLS
	1166	EXU81SCMU
	1167	EXU81SLFCU
	1168	EXU81SNAPLU
	1169	EXU81SNAPU
	1170	EXU81SPOKIU
	1171	EXU81SPOKU
	1172	EXU81SRTU
	1173	EXU81TABSU
	1174	EXU81TABU
	1175	EXU81TBCPU
	1176	EXU81TBSPU
	1177	EXU81TGRU
	1178	EXU81TYPU
	1179	EXU81USCIU
	1180	EXU8ANAL
	1181	EXU8ASCU
	1182	EXU8BSZ
	1183	EXU8CCLO
	1184	EXU8CCLU
	1185	EXU8CCOU
	1186	EXU8CGRU
	1187	EXU8CLUU
	1188	EXU8CMTU
	1189	EXU8COEU
	1190	EXU8COLU
	1191	EXU8CONU
	1192	EXU8COOU
	1193	EXU8CPO
	1194	EXU8CSET
	1195	EXU8CSNU
	1196	EXU8DIM
	1197	EXU8DIMU
	1198	EXU8FPTU
	1199	EXU8FUL
	1200	EXU8GLOB
	1201	EXU8GRNU
	1202	EXU8HSTU
	1203	EXU8ICO
	1204	EXU8ICOU
	1205	EXU8ICPLSQL
	1206	EXU8INDU
	1207	EXU8INKU
	1208	EXU8IOVU
	1209	EXU8IXPU
	1210	EXU8JBQU
	1211	EXU8LIBU
	1212	EXU8LNKU
	1213	EXU8LOBU
	1214	EXU8NTBU
	1215	EXU8NXPU
	1216	EXU8OIDU
	1217	EXU8OPT
	1218	EXU8ORD
	1219	EXU8ORDU
	1220	EXU8ORFS
	1221	EXU8PDSU
	1222	EXU8PNTU
	1223	EXU8POKIU
	1224	EXU8POKU
	1225	EXU8PSTU
	1226	EXU8REFU
	1227	EXU8RFSU
	1228	EXU8RGCU
	1229	EXU8RGSU
	1230	EXU8SCMU
	1231	EXU8SEQU
	1232	EXU8SLFCU
	1233	EXU8SLOGU
	1234	EXU8SNAPLU
	1235	EXU8SNAPU
	1236	EXU8SPSU
	1237	EXU8SPU
	1238	EXU8SRTU
	1239	EXU8STOU
	1240	EXU8SYNU
	1241	EXU8TABU
	1242	EXU8TBPU
	1243	EXU8TGRU
	1244	EXU8TNE
	1245	EXU8TNEB
	1246	EXU8TYPBU
	1247	EXU8TYPTU
	1248	EXU8TYPU
	1249	EXU8USCU
	1250	EXU8USRU
	1251	EXU8VDPTU
	1252	EXU8VER
	1253	EXU8VEWU
	1254	EXU8VINFU
	1255	EXU8VNCU
	1256	EXU92FPTPU
	1257	EXU92FPTU
	1258	EXU92TGRU
	1259	EXU92TSP
	1260	EXU92TSPL
	1261	EXU9ACTIONOBJ
	1262	EXU9BJF
	1263	EXU9BJW
	1264	EXU9CCLO
	1265	EXU9CCLU
	1266	EXU9COEU
	1267	EXU9COOU
	1268	EXU9DEFPSWITCHES
	1269	EXU9DOIU
	1270	EXU9DOSO
	1271	EXU9EIP
	1272	EXU9FGA
	1273	EXU9GSAS
	1274	EXU9IND
	1275	EXU9IND_BASE
	1276	EXU9INHCOLCONS
	1277	EXU9IXCPU
	1278	EXU9LBCPU
	1279	EXU9LBPU
	1280	EXU9LNKU
	1281	EXU9LOBU
	1282	EXU9MVL
	1283	EXU9MVLCDCCC
	1284	EXU9MVLCDCS
	1285	EXU9MVLCDCSC
	1286	EXU9MVLCDCST
	1287	EXU9MVLU
	1288	EXU9NLS
	1289	EXU9NOS
	1290	EXU9OBJSWITCH
	1291	EXU9OTNNULL
	1292	EXU9PCT
	1293	EXU9PDSU
	1294	EXU9PGP
	1295	EXU9PLBU
	1296	EXU9PTS
	1297	EXU9RLS
	1298	EXU9SNAPLU
	1299	EXU9SNAPU
	1300	EXU9STOU
	1301	EXU9SYNU
	1302	EXU9TABSU
	1303	EXU9TABU
	1304	EXU9TAB_UNUSED_COLS
	1305	EXU9TBCPU
	1306	EXU9TNE
	1307	EXU9TNEB
	1308	EXU9TYPTU
	1309	EXU9TYPTU2
	1310	EXU9TYPU
	1311	EXU9UTSU
	1312	EXU9XDBUID
	1313	EXU9XMLST
	1314	EXU9XTB
	1315	FLASHBACK_TRANSACTION_QUERY
	1316	GLOBAL_CONTEXT
	1317	GLOBAL_NAME
	1318	GV_$ACTIVE_INSTANCES
	1319	GV_$ACTIVE_SESS_POOL_MTH
	1320	GV_$AW_AGGREGATE_OP
	1321	GV_$AW_ALLOCATE_OP
	1322	GV_$AW_CALC
	1323	GV_$AW_LONGOPS
	1324	GV_$AW_OLAP
	1325	GV_$AW_SESSION_INFO
	1326	GV_$BH
	1327	GV_$BLOCKING_QUIESCE
	1328	GV_$LOADISTAT
	1329	GV_$LOADPSTAT
	1330	GV_$LOCK_ACTIVITY
	1331	GV_$MAX_ACTIVE_SESS_TARGET_MTH
	1332	GV_$NLS_PARAMETERS
	1333	GV_$NLS_VALID_VALUES
	1334	GV_$OPTION
	1335	GV_$PARALLEL_DEGREE_LIMIT_MTH
	1336	GV_$PQ_SESSTAT
	1337	GV_$PQ_TQSTAT
	1338	GV_$QUEUEING_MTH
	1339	GV_$RESTORE_POINT
	1340	GV_$RSRC_CONSUMER_GROUP
	1341	GV_$RSRC_CONSUME_GROUP_CPU_MTH
	1342	GV_$RSRC_CONS_GROUP_HISTORY
	1343	GV_$RSRC_PLAN
	1344	GV_$RSRC_PLAN_CPU_MTH
	1345	GV_$RSRC_PLAN_HISTORY
	1346	GV_$RSRC_SESSION_INFO
	1347	GV_$SESSION_LONGOPS
	1348	GV_$TEMPORARY_LOBS
	1349	GV_$TIMEZONE_FILE
	1350	GV_$TIMEZONE_NAMES
	1351	GV_$VERSION
	1352	IMP8CDTU
	1353	IMP8REPCAT
	1354	IMP8TTDU
	1355	IMP8UEC
	1356	IMP9COMPAT
	1357	IMP9SYN4
	1358	IMP9TVOID
	1359	IMP9USR
	1360	IMP_LOB_INFO
	1361	IMP_LOB_NOTNULL
	1362	IMP_TAB_TRIG
	1363	INDEX_HISTOGRAM
	1364	INDEX_STATS
	1365	KU$
	1366	KU_NOEXP_VIEW
	1367	LOADER_
	1368	NLS_DATABASE_PARAMETERS
	1369	NLS_INSTANCE_PARAMETERS
	1370	NLS_SESSION_PARAMETERS
	1371	ORA_KGLR7_DB_LINKS
	1372	ORA_KGLR7_DEPENDENCIES
	1373	ORA_KGLR7_IDL_CHAR
	1374	ORA_KGLR7_IDL_SB4
	1375	ORA_KGLR7_IDL_UB1
	1376	ORA_KGLR7_IDL_UB2
	1377	PRODUCT_COMPONENT_VERSION
	1378	PUBLICSYN
	1379	PUBLIC_DEPENDENCY
	1380	QUEUE_PRIVILEGES
	1381	RESOURCE_COST
	1382	ROLE_ROLE_PRIVS
	1383	ROLE_SYS_PRIVS
	1384	ROLE_TAB_PRIVS
	1385	SCHEMA_EXPORT_OBJECTS
	1386	SESSION_CONTEXT
	1387	SESSION_PRIVS
	1388	SESSION_ROLES
	1389	SM_$VERSION
	1390	SYNONYMS
	1391	SYSCATALOG
	1392	SYSFILES
	1393	SYSSEGOBJ
	1394	USER_
	1395	UTL_ALL_IND_COMPS
	1396	V$OBJECT_USAGE
	1397	V_$ACTIVE_INSTANCES
	1398	V_$ACTIVE_SESS_POOL_MTH
	1399	V_$ADVISOR_PROGRESS
	1400	V_$AW_AGGREGATE_OP
	1401	V_$AW_ALLOCATE_OP
	1402	V_$AW_CALC
	1403	V_$AW_LONGOPS
	1404	V_$AW_OLAP
	1405	V_$AW_SESSION_INFO
	1406	V_$BH
	1407	V_$BLOCKING_QUIESCE
	1408	V_$LOADISTAT
	1409	V_$LOADPSTAT
	1410	V_$LOCK_ACTIVITY
	1411	V_$MAX_ACTIVE_SESS_TARGET_MTH
	1412	V_$NLS_PARAMETERS
	1413	V_$NLS_VALID_VALUES
	1414	V_$OPTION
	1415	V_$PARALLEL_DEGREE_LIMIT_MTH
	1416	V_$PQ_SESSTAT
	1417	V_$PQ_TQSTAT
	1418	V_$QUEUEING_MTH
	1419	V_$RESTORE_POINT
	1420	V_$RSRC_CONSUMER_GROUP
	1421	V_$RSRC_CONSUMER_GROUP_CPU_MTH
	1422	V_$RSRC_CONS_GROUP_HISTORY
	1423	V_$RSRC_PLAN
	1424	V_$RSRC_PLAN_CPU_MTH
	1425	V_$RSRC_PLAN_HISTORY
	1426	V_$RSRC_SESSION_INFO
	1427	V_$SESSION_CONNECT_INFO
	1428	V_$SESSION_LONGOPS
	1429	V_$TEMPORARY_LOBS
	1430	V_$TIMEZONE_FILE
	1431	V_$TIMEZONE_NAMES
	1432	V_$VERSION
	1433	_ALL_FILE_GROUPS
	1434	_ALL_FILE_GROUP_EXPORT_INFO
	1435	_ALL_FILE_GROUP_FILES
	1436	_ALL_FILE_GROUP_TABLES
	1437	_ALL_FILE_GROUP_TABLESPACES
	1438	_ALL_FILE_GROUP_VERSIONS
	1439	_ALL_INSTANTIATION_DDL
	1440	_ALL_REPCOLUMN
	1441	_ALL_REPCOLUMN_GROUP
	1442	_ALL_REPCONFLICT
	1443	_ALL_REPEXTENSIONS
	1444	_ALL_REPFLAVOR_OBJECTS
	1445	_ALL_REPGROUPED_COLUMN
	1446	_ALL_REPPARAMETER_COLUMN
	1447	_ALL_REPRESOLUTION
	1448	_ALL_REPSITES_NEW
	1449	_ALL_SQLSET_STATEMENTS_ONLY
	1450	_ALL_SQLSET_STATEMENTS_PHV
	1451	_ALL_SQLSET_STATISTICS_ONLY
	1452	PRODUCT_PRIVS
	1453	DR$NUMBER_SEQUENCE
	1454	DR$OBJECT_ATTRIBUTE
	1455	DR$POLICY_TAB
	1456	BIN$qoPod3b/5/jgQAB/AQB1gw==$0
	1457	BIN$qoa+IroQdCDgQAB/AQAShg==$0
	1458	BIN$qoa+gX3av6bgQAB/AQASoA==$0
	1459	BIN$qoa97kXfAGHgQAB/AQASdw==$0
	1460	BIN$qoaJ7wJwYOLgQAB/AQAITA==$0
	1461	BIN$qoamIR+TOebgQAB/AQANmw==$0
	1462	BIN$qoamP2m44xXgQAB/AQANoA==$0
	1463	BIN$qoamm6N5i3bgQAB/AQANtg==$0
	1464	BIN$qob17xzsmp3gQAB/AQAgOA==$0
	1465	BIN$qod/Sxxh583gQAB/AQAGVg==$0
	1466	BIN$qod/pFQZipXgQAB/AQAGaw==$0
	1467	WWV_FLOW_DUAL100
	1468	WWV_FLOW_FIELD_TEMPLATES
	1469	WWV_FLOW_LISTS_OF_VALUES$
	1470	WWV_FLOW_LIST_OF_VALUES_DATA
	1471	WWV_FLOW_LOV_TEMP
	1472	WWV_FLOW_PATCHES
	1473	WWV_FLOW_TEMP_TABLE
	1474	OGIS_GEOMETRY_COLUMNS
	1475	OGIS_SPATIAL_REFERENCE_SYSTEMS
	1476	SDO_COORD_AXES
	1477	SDO_COORD_AXIS_NAMES
	1478	SDO_COORD_OPS
	1479	SDO_COORD_OP_METHODS
	1480	SDO_COORD_OP_PARAMS
	1481	SDO_COORD_OP_PARAM_USE
	1482	SDO_COORD_OP_PARAM_VALS
	1483	SDO_COORD_OP_PATHS
	1484	SDO_COORD_REF_SYS
	1485	SDO_COORD_SYS
	1486	SDO_CS_SRS
	1487	SDO_DATUMS
	1488	SDO_DATUMS_OLD_SNAPSHOT
	1489	SDO_ELLIPSOIDS
	1490	SDO_ELLIPSOIDS_OLD_SNAPSHOT
	1491	SDO_PREFERRED_OPS_SYSTEM
	1492	SDO_PREFERRED_OPS_USER
	1493	SDO_PRIME_MERIDIANS
	1494	SDO_PROJECTIONS_OLD_SNAPSHOT
	1495	SDO_TOPO_DATA$
	1496	SDO_TOPO_RELATION_DATA
	1497	SDO_TOPO_TRANSACT_DATA
	1498	SDO_TXN_IDX_DELETES
	1499	SDO_TXN_IDX_EXP_UPD_RGN
	1500	SDO_TXN_IDX_INSERTS
	1501	SDO_UNITS_OF_MEASURE
	1502	XDB$ACL
	1503	XDB$ALL_MODEL
	1504	XDB$ANY
	1505	XDB$ANYATTR
	1506	XDB$ATTRGROUP_DEF
	1507	XDB$ATTRGROUP_REF
	1508	XDB$ATTRIBUTE
	1509	XDB$CHOICE_MODEL
	1510	XDB$COMPLEX_TYPE
	1511	XDB$ELEMENT
	1512	XDB$GROUP_DEF
	1513	XDB$GROUP_REF
	1514	XDB$SCHEMA
	1515	XDB$SEQUENCE_MODEL
	1516	XDB$SIMPLE_TYPE
	1517	CTX_CLASSES
	1518	CTX_INDEX_SETS
	1519	CTX_INDEX_SET_INDEXES
	1520	CTX_OBJECTS
	1521	CTX_OBJECT_ATTRIBUTES
	1522	CTX_OBJECT_ATTRIBUTE_LOV
	1523	CTX_PARAMETERS
	1524	CTX_PREFERENCES
	1525	CTX_PREFERENCE_VALUES
	1526	CTX_SECTIONS
	1527	CTX_SECTION_GROUPS
	1528	CTX_SQES
	1529	CTX_STOPLISTS
	1530	CTX_STOPWORDS
	1531	CTX_SUB_LEXERS
	1532	CTX_THESAURI
	1533	CTX_THES_PHRASES
	1534	CTX_TRACE_VALUES
	1535	CTX_USER_INDEXES
	1536	CTX_USER_INDEX_ERRORS
	1537	CTX_USER_INDEX_OBJECTS
	1538	CTX_USER_INDEX_PARTITIONS
	1539	CTX_USER_INDEX_SETS
	1540	CTX_USER_INDEX_SET_INDEXES
	1541	CTX_USER_INDEX_SUB_LEXERS
	1542	CTX_USER_INDEX_SUB_LEXER_VALS
	1543	CTX_USER_INDEX_VALUES
	1544	CTX_USER_PENDING
	1545	CTX_USER_PREFERENCES
	1546	CTX_USER_PREFERENCE_VALUES
	1547	CTX_USER_SECTIONS
	1548	CTX_USER_SECTION_GROUPS
	1549	CTX_USER_SQES
	1550	CTX_USER_STOPLISTS
	1551	CTX_USER_STOPWORDS
	1552	CTX_USER_SUB_LEXERS
	1553	CTX_USER_THESAURI
	1554	CTX_USER_THES_PHRASES
	1555	DRV$DELETE
	1556	DRV$DELETE2
	1557	DRV$ONLINE_PENDING
	1558	DRV$PENDING
	1559	DRV$UNINDEXED
	1560	DRV$UNINDEXED2
	1561	DRV$WAITING
	1562	WWV_FLOW_CLICKTHRU_LOG
	1563	WWV_FLOW_COLLECTIONS
	1564	WWV_FLOW_FILES
	1565	WWV_FLOW_GROUP_USERS
	1566	WWV_FLOW_HOURS_12
	1567	WWV_FLOW_HOURS_24
	1568	WWV_FLOW_MINUTES
	1569	WWV_FLOW_MINUTES_5
	1570	WWV_FLOW_MONTHS_MON
	1571	WWV_FLOW_MONTHS_MONTH
	1572	WWV_FLOW_PLSQL_JOBS
	1573	WWV_FLOW_USERS
	1574	WWV_FLOW_USER_ACTIVITY_LOG
	1575	WWV_FLOW_USER_MAIL_LOG
	1576	WWV_FLOW_USER_MAIL_QUEUE
	1577	WWV_FLOW_YEARS
	1578	ALL_GEOMETRY_COLUMNS
	1579	ALL_SDO_GEOM_METADATA
	1580	ALL_SDO_INDEX_INFO
	1581	ALL_SDO_INDEX_METADATA
	1582	ALL_SDO_LRS_METADATA
	1583	ALL_SDO_MAPS
	1584	ALL_SDO_STYLES
	1585	ALL_SDO_THEMES
	1586	ALL_SDO_TOPO_INFO
	1587	ALL_SDO_TOPO_METADATA
	1588	CS_SRS
	1589	DBA_SDO_MAPS
	1590	DBA_SDO_STYLES
	1591	DBA_SDO_THEMES
	1592	GEODETIC_SRIDS
	1593	MY_SDO_INDEX_METADATA
	1594	SDO_ANGLE_UNITS
	1595	SDO_AREA_UNITS
	1596	SDO_AVAILABLE_ELEM_OPS
	1597	SDO_AVAILABLE_NON_ELEM_OPS
	1598	SDO_AVAILABLE_OPS
	1599	SDO_COORD_REF_SYSTEM
	1600	SDO_CRS_COMPOUND
	1601	SDO_CRS_ENGINEERING
	1602	SDO_CRS_GEOCENTRIC
	1603	SDO_CRS_GEOGRAPHIC2D
	1604	SDO_CRS_GEOGRAPHIC3D
	1605	SDO_CRS_PROJECTED
	1606	SDO_CRS_VERTICAL
	1607	SDO_DATUMS_OLD_FORMAT
	1608	SDO_DATUM_ENGINEERING
	1609	SDO_DATUM_GEODETIC
	1610	SDO_DATUM_VERTICAL
	1611	SDO_DIST_UNITS
	1612	SDO_ELLIPSOIDS_OLD_FORMAT
	1613	SDO_PROJECTIONS_OLD_FORMAT
	1614	SDO_RELATEMASK_TABLE
	1615	SDO_TOPO_TRANSACT_DATA$
	1616	USER_
	1617	PATH_VIEW
	1618	RESOURCE_VIEW
	1619	CHANGE_TABLES
	1620	DATAPUMP_TABLE_DATA
	1621	GV$DB_TRANSPORTABLE_PLATFORM
	1622	GV$FIXED_TABLE
	1623	GV$TABLESPACE
	1624	GV$TRANSPORTABLE_PLATFORM
	1625	OLAPRC_TABLE
	1626	OLAP_TABLE
	1627	ORA_IS_CREATING_NESTED_TABLE
	1628	SQL_PLAN_TABLE_TYPE
	1629	TABLESPACE_EXPORT_OBJECTS
	1630	TABLE_EXPORT_OBJECTS
	1631	TABLE_PRIVILEGES
	1632	TABLE_PRIVILEGE_MAP
	1633	TABQUOTAS
	1634	TABS
	1635	TRANSPORTABLE_EXPORT_OBJECTS
	1636	#;
	1637
	1638	@system_tables = map {quotemeta $_} @system_tables;
	1639	push @system_tables, 'BIN';
	1640	my $system_table_re = '^(' . join('\|', @system_tables) . ')';
prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	1641
test cleanup c7f934b Yuki Kimoto authored on 2011-08-15	1642	has exclude_table => sub {
	1643	return $system_table_re;
	1644	};
prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	1645
	1646	has dsn => 'dbi:Oracle:host=localhost;port=1521;sid=XE';
	1647	has user => 'dbix_custom';
	1648	has password => 'dbix_custom';
	1649
cleanup test f60e789 Yuki Kimoto authored on 2011-08-15	1650	sub create_table1 { "create table $table1 ($key1 varchar2(255), $key2 varchar2(255))" }
	1651	sub create_table1_2 { "create table $table1 ($key1 varchar2(255), $key2 varchar2(255), "
	1652	. "$key3 varchar2(255), $key4 varchar2(255), $key5 varchar2(255))" }
	1653	sub create_table1_type { "create table $table1 ($key1 $date_typename, $key2 $datetime_typename)" }
	1654	sub create_table1_highperformance { "create table $table1 ($key1 varchar2(255), $key2 varchar2(255), "
	1655	. "$key3 varchar2(255), $key4 varchar2(255), $key5 varchar2(255), $key6 varchar2(255), $key7 varchar2(255))" }
	1656	sub create_table2 { "create table $table2 ($key1 varchar2(255), $key3 varchar2(255))" }
	1657	sub create_table2_2 { "create table $table2 ($key1 varchar2(255), $key2 varchar2(255), $key3 varchar2(255))" }
	1658	sub create_table3 { "create table $table3 ($key1 varchar2(255), $key2 varchar2(255), $key3 varchar2(255))" }
prepare oracle test 6ab262d Yuki Kimoto authored on 2011-08-15	1659	sub create_table_reserved { 'create table "table" ("select" varchar2(255), "update" varchar2(255))' }
	1660	}
	1661
	1662	require "$FindBin::Bin/common.t";