kimoto/DBIx-Custom at a76f2207fa227d04661e50b3c9882df85c0fdb96 ・ Gitprep

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

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

1663 lines | 40.094kb

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