##########################################################

# __ __ _____ #

# | \ | | | | / __ \ #

# | \| |_ _| | | / \/_ __ _____ __ #

# | . ` | | | | | | | | '__/ _ \ \ /\ / / #

# | |\ | |_| | | | \__/\ | | __/\ V V / #

# \_| \_/\__,_|_|_|\____/_| \___| \_/\_/ #

# @OfficialNull - @0rbit_g1rl -@Saturnine_NC @Timoxeline #

##########################################################

______ _ _____ _ _____ _

| ___| | | |_ _| | / ___| | |

| |_ _ _ ___| | __ | | | |__ ___ \ `--. _ _ ___| |_ ___ _ __ ___

| _| | | |/ __| |/ / | | | '_ \ / _ \ `--. \ | | / __| __/ _ \ '_ ` _ \

| | | |_| | (__| < | | | | | | __/ /\__/ / |_| \__ \ || __/ | | | | |

\_| \__,_|\___|_|\_\ \_/ |_| |_|\___| \____/ \__, |___/\__\___|_| |_| |_|

__/ |

|___/

/"\

|\./|

| |

| |

|>~<|

| |

/'\| |/'\..

/~\| | | | \

| =[@]= | | \

| | | | | \

| ~ ~ ~ ~ |` )

| /

\ /

\ /

\ _____ /

|--//''`\--|

| (( +==)) |

|--\_|_//--|

We warned you of the upcoming #FuckTheSystem operation, and now here is the first part of the zine.

This zine contains information from servers of Government, and Corporations whom are apart of the hated system.

These Corprate giant's, and Government officials have pushed us to make this zine; as we still have access to the servers.

If they attempt to retaliate against us, we will be back to repeate the process again; as they can _NOT_ censor us; nor can they censor YOU.

With this note, I hope that the people can finally understand us a bit more; a bit more to the instance that we are not playing around.

It is no longer fun and games, and the fact that this has become strictly a plot of revenge against the system, people have predicted it for years..

A revolt against the system, well then; is it time?

Let's find out..

_________________________________

|Table of contents: |

|Foxconn & SwaggSec. |

|State.gov |

|_________________________________|

Foxconn.com & SwaggSecurity

┌───────────────────‐-----------------

｜I'm tired of these goddamned hackers|

｜On our goddamned servers! |

\──|─|───────────――-----------------/

.-\ \/

|/,-'`

_.-'''-._

/` __ __ `\

___ ;__.--._.--.__;

/ /\ ( O / \ O ) `\

| _\/_ '-' '-' _/

_|_|' | (_) |

/ __) | |

| __) | .___. | .-. _

| ___)'; /\.-./\ ; | | / |

|~||/\ .\ `-` / __| |/ /_

| \_\/==;'._ - _.'__ (_ _)

\ 8 /\"""""/\ `\ `| .'`

'--8----.`-`\^/`-`. \ |~~|

8 | /~\ |`\ \ | |

8 | |\| | \ `y |

8 | |\| | \ /

8 | |\| | '.__.'

8 |___|\|___|

8 |===\_/===|

Okay, SwaggSec; you took the database of foxconn, correct?

Well, we'll one up you with site disclosure of several degrees.

And to Foxconn, stop pushing your workers to the point of suicide.

Or next time, it won't be just a few database and table names; it'll be the full complete db for download.

I'll start with one note:

Foxconn's IT department is the most laughable thing I have ever seen.

Exploits ranging from time based blind, to boolean-based blind.

Then even abituary file upload..

rfq.foxconn.com:

Let's start with you, you wised up whenever you noticed us including a .htaccess file; then shell on your server.

This allowed us to have access for a few days, we should have taken data; but for those of you who do not know what this exploit is..

It is basicially uploading a file through the fckeditor, which if the upload prompt is avaliable can be used to upload an updated .htaccess file.

And then your shell, because that allows your shell to be on the server, but the main directory so no goose chase there.

wh.foxconn.com:

You on the other hand..

You are more laughable then the last one, your sys.database_files avaliable to anyone capable of exploiting the boolean-based blind sql injection.

Not just that, but several other databases containing interesting information; such as:

sys.database_mirroring

sys.database_permissions

sys.credentials

sys.crypt_properties

Etc.

Why would we sit here and allow such a juicy oppertunity to pass us?

On the same domain, they have a MySQL time based injection, laughable.

Considering it's the same subdomain, there are all the same files; just obtainable through a different exploit.

Let's put some data out:

Databases:

master

model

msdb

ReportServer

ReportServerTempDB

tempdb

whfoxc

What about some tables?

We won't expose to much, not even the actual data (yet.)

As this is just a teaser for you to enjoy.

The below table names are from the master database.

dbo.sys.credentials

sys.database_files

Columns from one of those two databases?

dbo.sys.credentials:

create_date

credential_id

credential_identity

modify_date

name

Enough embarrasment on this server.

Let's move onto our next targert.

State.gov & Corruption.

Jesus christ, this one took a bit; and was more data then I had originally imagined.

state.gov, a popular united states web server; however, this server being unsecure as fuck.

Basis of oracle databases, unsecure at that; leading to this attack.

To those of you who do not know how to use oracle injection, this one was more annoying then regular; it was blind base.

And blind base with oracle, is a real bitch at times..

However, this not being the only error; it also has links to other servers that we have root access to, these other servers are linked directly back to this one in a certian directory.

So, gain root to one; get root to this.

The exploit used for the data below was oracle blind base sql injection, as stated before; but the other ones we had found will remain unknown, but I will say this..

They have the same aspect as a regular LFi, but dealing with a different form of file extension even, for a different type of adobe product.

This exploit is my own person -redacted- file bypass 0day.

Now, the reason we had attacked you guys though; not just because of corruption, but because of your idiocy, the fact that you are growing more corruptr by the moment.

Hungry for the power that grows in your hands, and if we do not see a change; then we will have to force a change, right now we are sitting on atleast 200+ FBI and CIA agent's dox.

We regret to inform you, that even if you patch this one exploit; we will always be able to find another way in.

<--Databases on iew.state.gov-->

CTXSYS

EXFSYS

IEW

MDSYS

OLAPSYS

SYS

SYSTEM

Let's start by dumping data of the main database.

Database: IEW

Alright, the first thing that cought our eyes in the tables of this db; was "USER_REF."

`So, we execute; and obtain the data, which has the columns:

CREATED_DATE

USER_EMAIL

USER_ID

USER_NAME

USER_PASS

USER_ROLE_ID

Below is the most interesting data obtained from this table.

<--Emails from USER_REF-->

MoradiBX@state.gov,carteraa@state.gov

<--Usernames from USER_REF-->

webmaster,admin

<--Passwords from USER_REF related to the above emails, and username-->

iew0927,waiter99

<--Table and column's full list-->

Database: EXFSYS

[1 table]

+--------------------------------+

| RLM$PARSEDCOND |

+--------------------------------+

Database: OLAPSYS

[2 tables]

+--------------------------------+

| OLAP_SESSION_CUBES |

| OLAP_SESSION_DIMS |

+--------------------------------+

Database: SYSTEM

[8 tables]

+--------------------------------+

| DEF$_TEMP$LOB |

| HELP |

| MVIEW$_ADV_INDEX |

| MVIEW$_ADV_OWB |

| MVIEW$_ADV_PARTITION |

| OL$ |

| OL$HINTS |

| OL$NODES |

+--------------------------------+

Database: IEW

[12 tables]

+--------------------------------+

| CNTRY_REF |

| CNTRY_TO_REGION |

| CUSTOM_PAGE_REF |

| EVENTS_REF |

| EVENTS_TO_CUSTOM_PAGE |

| EVENT_PHOTO_REF |

| EVENT_REPORT_REF |

| ORG_TYPE_REF |

| REGION_REF |

| STATE_REF |

| USER_REF |

| USER_ROLE_REF |

+--------------------------------+

Database: SYS

[25 tables]

+--------------------------------+

| AUDIT_ACTIONS |

| AW$AWCREATE |

| AW$AWCREATE10G |

| AW$AWMD |

| AW$AWREPORT |

| AW$AWXML |

| AW$EXPRESS |

| DUAL |

| IMPDP_STATS |

| KU$NOEXP_TAB |

| KU$_LIST_FILTER_TEMP |

| ODCI_SECOBJ$ |

| ODCI_WARNINGS$ |

| OLAPTABLEVELS |

| OLAPTABLEVELTUPLES |

| OLAP_OLEDB_FUNCTIONS_PVT |

| OLAP_OLEDB_KEYWORDS |

| OLAP_OLEDB_MDPROPS |

| OLAP_OLEDB_MDPROPVALS |

| PLAN_TABLE$ |

| PSTUBTBL |

| STMT_AUDIT_OPTION_MAP |

| SYSTEM_PRIVILEGE_MAP |

| TABLE_PRIVILEGE_MAP |

| WRI$_ADV_ASA_RECO_DATA |

+--------------------------------+

Database: MDSYS

[37 tables]

+--------------------------------+

| 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_GEOR_PLUGIN_REGISTRY |

| SDO_GEOR_XMLSCHEMA_TABLE |

| SDO_GR_MOSAIC_0 |

| SDO_GR_MOSAIC_1 |

| SDO_GR_MOSAIC_2 |

| SDO_GR_MOSAIC_3 |

| SDO_GR_RDT_1 |

| SDO_PREFERRED_OPS_SYSTEM |

| SDO_PREFERRED_OPS_USER |

| SDO_PRIME_MERIDIANS |

| SDO_PROJECTIONS_OLD_SNAPSHOT |

| SDO_ST_TOLERANCE |

| 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 |

| SDO_XML_SCHEMAS |

+--------------------------------+

Database: CTXSYS

[3 tables]

+--------------------------------+

| DR$NUMBER_SEQUENCE |

| DR$OBJECT_ATTRIBUTE |

| DR$POLICY_TAB |

+--------------------------------+

Database: SYS

Table: IMPDP_STATS

[25 columns]

+---------+----------+

| Column | Type |

+---------+----------+

| C1 | VARCHAR2 |

| C2 | VARCHAR2 |

| C3 | VARCHAR2 |

| C4 | VARCHAR2 |

| C5 | VARCHAR2 |

| CH1 | VARCHAR2 |

| D1 | DATE |

| FLAGS | NUMBER |

| N1 | NUMBER |

| N10 | NUMBER |

| N11 | NUMBER |

| N12 | NUMBER |

| N2 | NUMBER |

| N3 | NUMBER |

| N4 | NUMBER |

| N5 | NUMBER |

| N6 | NUMBER |

| N7 | NUMBER |

| N8 | NUMBER |

| N9 | NUMBER |

| R1 | RAW |

| R2 | RAW |

| STATID | VARCHAR2 |

| TYPE | CHAR |

| VERSION | NUMBER |

+---------+----------+

Database: SYS

Table: OLAPTABLEVELS

[6 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| CUBE_NAME | VARCHAR2 |

| DIMENSION_NAME | VARCHAR2 |

| DIMENSION_OWNER | VARCHAR2 |

| LEVEL_NAME | VARCHAR2 |

| SCHEMA_NAME | VARCHAR2 |

| SELECTED | NUMBER |

+-----------------+----------+

Database: SYS

Table: AW$AWREPORT

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: ODCI_WARNINGS$

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| C1 | NUMBER |

| C2 | VARCHAR2 |

+--------+----------+

Database: SYS

Table: DUAL

[1 column]

+--------+----------+

| Column | Type |

+--------+----------+

| DUMMY | VARCHAR2 |

+--------+----------+

Database: SYS

Table: OLAP_OLEDB_MDPROPVALS

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| NAME | VARCHAR2 |

| VALUE | NUMBER |

+--------+----------+

Database: SYS

Table: OLAP_OLEDB_FUNCTIONS_PVT

[8 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| CAPTION | VARCHAR2 |

| DESCRIPTION | VARCHAR2 |

| FUNCTION_NAME | VARCHAR2 |

| INTERFACE_NAME | VARCHAR2 |

| OBJECT | VARCHAR2 |

| ORIGIN | NUMBER |

| PARAMETER_LIST | VARCHAR2 |

| RETURN_TYPE | NUMBER |

+----------------+----------+

Database: SYS

Table: AW$EXPRESS

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: AW$AWCREATE10G

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: KU$NOEXP_TAB

[3 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| NAME | VARCHAR2 |

| OBJ_TYPE | VARCHAR2 |

| SCHEMA | VARCHAR2 |

+----------+----------+

Database: SYS

Table: OLAP_OLEDB_KEYWORDS

[1 column]

+---------+----------+

| Column | Type |

+---------+----------+

| KEYWORD | VARCHAR2 |

+---------+----------+

Database: SYS

Table: TABLE_PRIVILEGE_MAP

[2 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| NAME | VARCHAR2 |

| PRIVILEGE | NUMBER |

+-----------+----------+

Database: SYS

Table: PSTUBTBL

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| DBNAME | VARCHAR2 |

| LINE | VARCHAR2 |

| LINENO | NUMBER |

| LUN | VARCHAR2 |

| LUTYPE | VARCHAR2 |

| USERNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: AW$AWCREATE

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: PLAN_TABLE$

[36 columns]

+-------------------+----------+

| Column | Type |

+-------------------+----------+

| ACCESS_PREDICATES | VARCHAR2 |

| BYTES | NUMBER |

| CARDINALITY | NUMBER |

| COST | NUMBER |

| CPU_COST | NUMBER |

| DEPTH | NUMBER |

| DISTRIBUTION | VARCHAR2 |

| FILTER_PREDICATES | VARCHAR2 |

| ID | NUMBER |

| IO_COST | NUMBER |

| OBJECT_ALIAS | VARCHAR2 |

| OBJECT_INSTANCE | NUMBER |

| OBJECT_NAME | VARCHAR2 |

| OBJECT_NODE | VARCHAR2 |

| OBJECT_OWNER | VARCHAR2 |

| OBJECT_TYPE | VARCHAR2 |

| OPERATION | VARCHAR2 |

| OPTIMIZER | VARCHAR2 |

| OPTIONS | VARCHAR2 |

| OTHER | LONG |

| OTHER_TAG | VARCHAR2 |

| OTHER_XML | CLOB |

| PARENT_ID | NUMBER |

| PARTITION_ID | NUMBER |

| PARTITION_START | VARCHAR2 |

| PARTITION_STOP | VARCHAR2 |

| PLAN_ID | NUMBER |

| POSITION | NUMBER |

| PROJECTION | VARCHAR2 |

| QBLOCK_NAME | VARCHAR2 |

| REMARKS | VARCHAR2 |

| SEARCH_COLUMNS | NUMBER |

| STATEMENT_ID | VARCHAR2 |

| TEMP_SPACE | NUMBER |

| TIME | NUMBER |

| TIMESTAMP | DATE |

+-------------------+----------+

Database: SYS

Table: AUDIT_ACTIONS

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| ACTION | NUMBER |

| NAME | VARCHAR2 |

+--------+----------+

Database: SYS

Table: ODCI_SECOBJ$

[4 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| IDXNAME | VARCHAR2 |

| IDXSCHEMA | VARCHAR2 |

| SECOBJNAME | VARCHAR2 |

| SECOBJSCHEMA | VARCHAR2 |

+--------------+----------+

Database: SYS

Table: OLAPTABLEVELTUPLES

[9 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| CUBE_NAME | VARCHAR2 |

| DIMENSION_NAME | VARCHAR2 |

| DIMENSION_OWNER | VARCHAR2 |

| ID | NUMBER |

| LEVEL_NAME | VARCHAR2 |

| PCT_OF_TOTAL | NUMBER |

| ROW_COUNT | NUMBER |

| SCHEMA_NAME | VARCHAR2 |

| SELECTED | NUMBER |

+-----------------+----------+

Database: SYS

Table: OLAP_OLEDB_MDPROPS

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| TYPE | VARCHAR2 |

| VALUE | VARCHAR2 |

+--------+----------+

Database: SYS

Table: WRI$_ADV_ASA_RECO_DATA

[16 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| ALSP | NUMBER |

| BENEFIT_TYPE | NUMBER |

| C1 | VARCHAR2 |

| C2 | VARCHAR2 |

| C3 | VARCHAR2 |

| CHCT | NUMBER |

| CMD_ID | NUMBER |

| CTIME |

| PARTNAME | VARCHAR2 |

| REC | NUMBER |

| SEGNAME | VARCHAR2 |

| SEGOWNER | VARCHAR2 |

| SEGTYPE | VARCHAR2 |

| TASK_ID | NUMBER |

| TSNAME | VARCHAR2 |

| USP | NUMBER |

+--------------+----------+

Database: SYS

Table: KU$_LIST_FILTER_TEMP

[4 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| BASE_PROCESS_ORDER | NUMBER |

| DUPLICATE | NUMBER |

| OBJECT_NAME | VARCHAR2 |

| PROCESS_ORDER | NUMBER |

+--------------------+----------+

Database: SYS

Table: AW$AWXML

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: STMT_AUDIT_OPTION_MAP

[3 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| "OPTION#" | NUMBER |

| NAME | VARCHAR2 |

| PROPERTY | NUMBER |

+-----------+----------+

Database: SYS

Table: SYSTEM_PRIVILEGE_MAP

[3 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| NAME | VARCHAR2 |

| PRIVILEGE | NUMBER |

| PROPERTY | NUMBER |

+-----------+----------+

Database: SYS

Table: AW$AWMD

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: OLAPSYS

Table: OLAP_SESSION_DIMS

[2 columns]

+------------+--------+

| Column | Type |

+------------+--------+

| ID | NUMBER |

| VERSION_ID | CHAR |

+------------+--------+

Database: OLAPSYS

Table: OLAP_SESSION_CUBES

[2 columns]

+------------+--------+

| Column | Type |

+------------+--------+

| ID | NUMBER |

| VERSION_ID | CHAR |

+------------+--------+

Database: SYSTEM

Table: MVIEW$_ADV_PARTITION

[4 columns]

+---------------+----------+

| Column | Type |

+---------------+----------+

| "RANK#" | NUMBER |

| "RUNID#" | NUMBER |

| QUERY_TEXT | LONG |

| SUMMARY_OWNER | VARCHAR2 |

+---------------+----------+

Database: SYSTEM

Table: OL$

[14 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| CATEGORY | VARCHAR2 |

| CREATOR | VARCHAR2 |

| FLAGS | NUMBER |

| HASH_VALUE | NUMBER |

| HASH_VALUE2 | NUMBER |

| HINTCOUNT | NUMBER |

| OL_NAME | VARCHAR2 |

| SIGNATURE | RAW |

| SPARE1 | NUMBER |

| SPARE2 | VARCHAR2 |

| SQL_TEXT | LONG |

| TEXTLEN | NUMBER |

| TIMESTAMP | DATE |

| VERSION | VARCHAR2 |

+-------------+----------+

Database: SYSTEM

Table: HELP

[3 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| INFO | VARCHAR2 |

| SEQ | NUMBER |

| TOPIC | VARCHAR2 |

+--------+----------+

Database: SYSTEM

Table: OL$NODES

[8 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| CATEGORY | VARCHAR2 |

| NODE_ID | NUMBER |

| NODE_NAME | VARCHAR2 |

| NODE_TEXTLEN | NUMBER |

| NODE_TEXTOFF | NUMBER |

| NODE_TYPE | NUMBER |

| OL_NAME | VARCHAR2 |

| PARENT_ID | NUMBER |

+--------------+----------+

Database: SYSTEM

Table: MVIEW$_ADV_OWB

[5 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| "RUNID#" | NUMBER |

| INDEXSCRIPT | CLOB |

| MVSCRIPT | CLOB |

| OBJNAME | VARCHAR2 |

| OWNERNAME | VARCHAR2 |

+-------------+----------+

Database: SYSTEM

Table: DEF$_TEMP$LOB

[3 columns]

+------------+-------+

| Column | Type |

+------------+-------+

| TEMP$BLOB | BLOB |

| TEMP$CLOB | CLOB |

| TEMP$NCLOB | NCLOB |

+------------+-------+

Database: SYSTEM

Table: OL$HINTS

[21 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| "HINT#" | NUMBER |

| "NODE#" | NUMBER |

| "STAGE#" | NUMBER |

| BYTES | FLOAT |

| CARDINALITY | FLOAT |

| CATEGORY | VARCHAR2 |

| COST | FLOAT |

| HINT_STRING | CLOB |

| HINT_TEXT | VARCHAR2 |

| HINT_TEXTLEN | NUMBER |

| HINT_TEXTOFF | NUMBER |

| HINT_TYPE | NUMBER |

| JOIN_PRED | VARCHAR2 |

| OL_NAME | VARCHAR2 |

| REF_ID | NUMBER |

| SPARE1 | NUMBER |

| SPARE2 | NUMBER |

| TABLE_NAME | VARCHAR2 |

| TABLE_POS | NUMBER |

| TABLE_TIN | NUMBER |

| USER_TABLE_NAME | VARCHAR2 |

+-----------------+----------+

Database: SYSTEM

Table: MVIEW$_ADV_INDEX

[8 columns]

+---------------+----------+

| Column | Type |

+---------------+----------+

| "MVINDEX#" | NUMBER |

| "RANK#" | NUMBER |

| "RUNID#" | NUMBER |

| COLUMN_NAME | VARCHAR2 |

| INDEX_CONTENT | VARCHAR2 |

| INDEX_NAME | VARCHAR2 |

| INDEX_TYPE | NUMBER |

| SUMMARY_OWNER | VARCHAR2 |

+---------------+----------+

Database: IEW

Table: USER_REF

[6 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| CREATED_DATE | DATE |

| USER_EMAIL | VARCHAR2 |

| USER_ID | NUMBER |

| USER_NAME | VARCHAR2 |

| USER_PASS | VARCHAR2 |

| USER_ROLE_ID | NUMBER |

+--------------+----------+

Database: IEW

Table: ORG_TYPE_REF

[5 columns]

+-----------------------+----------+

| Column | Type |

+-----------------------+----------+

| ORG_TYPE_ID | NUMBER |

| ORG_TYPE_NAME | VARCHAR2 |

| ORG_TYPE_NAME_DISPLAY | VARCHAR2 |

| ORG_TYPE_NAME_SHORT | VARCHAR2 |

| SORT_PRIORITY | NUMBER |

+-----------------------+----------+

Database: IEW

Table: CUSTOM_PAGE_REF

[7 columns]

+----------------------+----------+

| Column | Type |

+----------------------+----------+

| CNTRY_CODE | VARCHAR2 |

| CREATED_DATE | DATE |

| CUSTOM_PAGE_ID | NUMBER |

| CUSTOM_PAGE_NAME | VARCHAR2 |

| CUSTOM_PAGE_TEMPLATE | VARCHAR2 |

| REGION_CODE | VARCHAR2 |

| STATE_CODE | VARCHAR2 |

+----------------------+----------+

Database: IEW

Table: STATE_REF

[2 columns]

+------------+----------+

| Column | Type |

+------------+----------+

| STATE_CODE | VARCHAR2 |

| STATE_NAME | VARCHAR2 |

+------------+----------+

Database: IEW

Table: EVENTS_REF

[27 columns]

+-----------------------+----------+

| Column | Type |

+-----------------------+----------+

| CONTACT_EMAIL | VARCHAR2 |

| CONTACT_NAME | VARCHAR2 |

| CONTACT_TITLE | VARCHAR2 |

| CREATE_USER_ID | NUMBER |

| CREATED_DATE | DATE |

| EVENT_CITY | VARCHAR2 |

| EVENT_CNTRY_CODE | VARCHAR2 |

| EVENT_DESC | VARCHAR2 |

| EVENT_DESC_LONG | CLOB |

| EVENT_EMAIL | VARCHAR2 |

| EVENT_END_DATE | DATE |

| EVENT_END_DATE_MASK | VARCHAR2 |

| EVENT_ID | NUMBER |

| EVENT_LOC | VARCHAR2 |

| EVENT_ORG_NAME | VARCHAR2 |

| EVENT_START_DATE | DATE |

| EVENT_START_DATE_MASK | VARCHAR2 |

| EVENT_STATE_CODE | VARCHAR2 |

| EVENT_URL | VARCHAR2 |

| EVENT_YEAR | VARCHAR2 |

| IS_APPROVED | NUMBER |

| ORG_TYPE_ID | NUMBER |

| TOKEN | VARCHAR2 |

| UPDATE_DATE | DATE |

| UPDATE_USER_ID | NUMBER |

| WEB_DATE | DATE |

| WEB_USER_ID | NUMBER |

+-----------------------+----------+

Database: IEW

Table: CNTRY_REF

[2 columns]

+------------+----------+

| Column | Type |

+------------+----------+

| CNTRY_CODE | VARCHAR2 |

| CNTRY_NAME | VARCHAR2 |

+------------+----------+

Database: IEW

Table: REGION_REF

[2 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| REGION_CODE | VARCHAR2 |

| REGION_NAME | VARCHAR2 |

+-------------+----------+

Database: IEW

Table: CNTRY_TO_REGION

[2 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| CNTRY_CODE | VARCHAR2 |

| REGION_CODE | VARCHAR2 |

+-------------+----------+

Database: IEW

Table: EVENTS_TO_CUSTOM_PAGE

[4 columns]

+----------------+--------+

| Column | Type |

+----------------+--------+

| CREATED_DATE | DATE |

| CUSTOM_PAGE_ID | NUMBER |

| EVENT_ID | NUMBER |

| USER_ID | NUMBER |

+----------------+--------+

Database: IEW

Table: EVENT_REPORT_REF

[7 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| EVENT_ID | NUMBER |

| IS_APPROVED | NUMBER |

| REPORT_DATE | DATE |

| REPORT_HTML | VARCHAR2 |

| REPORT_ID | NUMBER |

| REPORT_NOTES | VARCHAR2 |

| REPORT_SRC | VARCHAR2 |

+--------------+----------+

Database: IEW

Table: EVENT_PHOTO_REF

[8 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| EVENT_ID | NUMBER |

| IS_APPROVED | NUMBER |

| PHOTO_CREDIT | VARCHAR2 |

| PHOTO_DATE | DATE |

| PHOTO_DESC | VARCHAR2 |

| PHOTO_ID | NUMBER |

| PHOTO_SRC | VARCHAR2 |

| SUBMIT_DATE | DATE |

+--------------+----------+

Database: IEW

Table: USER_ROLE_REF

[6 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| ACCESS_LEVEL | NUMBER |

| CREATED_DATE | DATE |

| CUSTOM_PAGE_ID | NUMBER |

| IS_READONLY | NUMBER |

| USER_ROLE_ID | NUMBER |

| USER_ROLE_NAME | VARCHAR2 |

+----------------+----------+

Database: EXFSYS

Table: RLM$PARSEDCOND

[3 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| PESEQPOS | NUMBER |

| TAGNAME | VARCHAR2 |

| TAGVALUE | VARCHAR2 |

+----------+----------+

Database: MDSYS

Table: SDO_COORD_SYS

[6 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| COORD_SYS_ID | NUMBER |

| COORD_SYS_NAME | VARCHAR2 |

| COORD_SYS_TYPE | VARCHAR2 |

| DATA_SOURCE | VARCHAR2 |

| DIMENSION | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PARAMS

[4 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| PARAMETER_ID | NUMBER |

| PARAMETER_NAME | VARCHAR2 |

+--------------------+----------+

Database: MDSYS

Table: OGIS_SPATIAL_REFERENCE_SYSTEMS

[5 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| AUTH_NAME | VARCHAR2 |

| AUTH_SRID | NUMBER |

| SRID | NUMBER |

| SRNUM | NUMBER |

| SRTEXT | VARCHAR2 |

+-----------+----------+

Database: MDSYS

Table: SDO_GR_MOSAIC_0

[27 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| B0 | NUMBER |

| B1 | NUMBER |

| BANDS | NUMBER |

| BBLKSZ | NUMBER |

| BCV | NUMBER |

| C0 | NUMBER |

| C1 | NUMBER |

| CBLKSZ | NUMBER |

| CDL | NUMBER |

| CDP | VARCHAR2 |

| COLS | NUMBER |

| CPTYPE | VARCHAR2 |

| ILV | VARCHAR2 |

| META | XMLTYPE |

| R0 | NUMBER |

| R1 | NUMBER |

| RBLKSZ | NUMBER |

| RCTIF | VARCHAR2 |

| RDT | VARCHAR2 |

| RID | ROWID |

| RROWS | NUMBER |

| RSTID | NUMBER |

| RSTYPE | NUMBER |

| SRID | NUMBER |

| ULTB | NUMBER |

| ULTC | NUMBER |

| ULTR | NUMBER |

+--------+----------+

Database: MDSYS

Table: SDO_GR_MOSAIC_3

[1 column]

+--------+--------+

| Column | Type |

+--------+--------+

| P | NUMBER |

+--------+--------+

Database: MDSYS

Table: SDO_GR_MOSAIC_2

[11 columns]

+--------+--------+

| Column | Type |

+--------+--------+

| B0 | NUMBER |

| B1 | NUMBER |

| C0 | NUMBER |

| C1 | NUMBER |

| CSIZE | NUMBER |

| R0 | NUMBER |

| R1 | NUMBER |

| RID | ROWID |

| RSIZE | NUMBER |

| ULTC | NUMBER |

| ULTR | NUMBER |

+--------+--------+

Database: MDSYS

Table: SDO_TXN_IDX_EXP_UPD_RGN

[10 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| END_1 | NUMBER |

| END_2 | NUMBER |

| END_3 | NUMBER |

| END_4 | NUMBER |

| RID | VARCHAR2 |

| SDO_TXN_IDX_ID | VARCHAR2 |

| START_1 | NUMBER |

| START_2 | NUMBER |

| START_3 | NUMBER |

| START_4 | NUMBER |

+----------------+----------+

Database: MDSYS

Table: SDO_XML_SCHEMAS

[3 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| DESCRIPTION | VARCHAR2 |

| ID | NUMBER |

| XMLSCHEMA | CLOB |

+-------------+----------+

Database: MDSYS

Table: SDO_GEOR_XMLSCHEMA_TABLE

[3 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| GEORASTERFORMAT | VARCHAR2 |

| ID | NUMBER |

| XMLSCHEMA | CLOB |

+-----------------+----------+

Database: MDSYS

Table: SDO_TXN_IDX_INSERTS

[10 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| END_1 | NUMBER |

| END_2 | NUMBER |

| END_3 | NUMBER |

| END_4 | NUMBER |

| RID | VARCHAR2 |

| SDO_TXN_IDX_ID | VARCHAR2 |

| START_1 | NUMBER |

| START_2 | NUMBER |

| START_3 | NUMBER |

| START_4 | NUMBER |

+----------------+----------+

Database: MDSYS

Table: OGIS_GEOMETRY_COLUMNS

[10 columns]

+-------------------+----------+

| Column | Type |

+-------------------+----------+

| COORD_DIMENSION | NUMBER |

| F_GEOMETRY_COLUMN | VARCHAR2 |

| F_TABLE_NAME | VARCHAR2 |

| F_TABLE_SCHEMA | VARCHAR2 |

| G_TABLE_NAME | VARCHAR2 |

| G_TABLE_SCHEMA | VARCHAR2 |

| GEOMETRY_TYPE | NUMBER |

| MAX_PPR | NUMBER |

| SRID | NUMBER |

| STORAGE_TYPE | NUMBER |

+-------------------+----------+

Database: MDSYS

Table: SDO_ELLIPSOIDS_OLD_SNAPSHOT

[3 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| INVERSE_FLATTENING | NUMBER |

| NAME | VARCHAR2 |

| SEMI_MAJOR_AXIS | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_AXES

[6 columns]

+-------------------------+----------+

| Column | Type |

+-------------------------+----------+

| COORD_AXIS_ABBREVIATION | VARCHAR2 |

| COORD_AXIS_NAME_ID | NUMBER |

| COORD_AXIS_ORIENTATION | VARCHAR2 |

| COORD_SYS_ID | NUMBER |

| ORDER | NUMBER |

| UOM_ID | NUMBER |

+-------------------------+----------+

Database: MDSYS

Table: SDO_CS_SRS

[6 columns]

+-----------+--------------+

| Column | Type |

+-----------+--------------+

| AUTH_NAME | VARCHAR2 |

| AUTH_SRID | NUMBER |

| CS_BOUNDS | SDO_GEOMETRY |

| CS_NAME | VARCHAR2 |

| SRID | NUMBER |

| WKTEXT | VARCHAR2 |

+-----------+--------------+

Database: MDSYS

Table: SDO_UNITS_OF_MEASURE

[12 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| FACTOR_B | NUMBER |

| FACTOR_C | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| LEGACY_UNIT_NAME | VARCHAR2 |

| SHORT_NAME | VARCHAR2 |

| TARGET_UOM_ID | NUMBER |

| UNIT_OF_MEAS_NAME | VARCHAR2 |

| UNIT_OF_MEAS_TYPE | VARCHAR2 |

| UOM_ID | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_AXIS_NAMES

[2 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| COORD_AXIS_NAME | VARCHAR2 |

| COORD_AXIS_NAME_ID | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_GR_MOSAIC_1

[11 columns]

+--------+--------+

| Column | Type |

+--------+--------+

| B0 | NUMBER |

| B1 | NUMBER |

| C0 | NUMBER |

| C1 | NUMBER |

| CSIZE | NUMBER |

| R0 | NUMBER |

| R1 | NUMBER |

| RID | ROWID |

| RSIZE | NUMBER |

| ULTC | NUMBER |

| ULTR | NUMBER |

+--------+--------+

Database: MDSYS

Table: SDO_ELLIPSOIDS

[10 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| ELLIPSOID_ID | NUMBER |

| ELLIPSOID_NAME | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| INV_FLATTENING | NUMBER |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| SEMI_MAJOR_AXIS | NUMBER |

| SEMI_MINOR_AXIS | NUMBER |

| UOM_ID | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_PREFERRED_OPS_USER

[4 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| COORD_OP_ID | NUMBER |

| SOURCE_SRID | NUMBER |

| TARGET_SRID | NUMBER |

| USE_CASE | VARCHAR2 |

+-------------+----------+

Database: MDSYS

Table: SDO_TOPO_DATA$

[5 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| TG_ID | NUMBER |

| TG_LAYER_ID | NUMBER |

| TOPO_ID | NUMBER |

| TOPO_TYPE | NUMBER |

| TOPOLOGY | VARCHAR2 |

+-------------+----------+

Database: MDSYS

Table: SDO_PROJECTIONS_OLD_SNAPSHOT

[1 column]

+--------+----------+

| Column | Type |

+--------+----------+

| NAME | VARCHAR2 |

+--------+----------+

Database: MDSYS

Table: SDO_TOPO_TRANSACT_DATA

[6 columns]

+---------------+----------+

| Column | Type |

+---------------+----------+

| PARENT_ID | NUMBER |

| TOPO_ID | NUMBER |

| TOPO_OP | VARCHAR2 |

| TOPO_SEQUENCE | NUMBER |

| TOPO_TYPE | NUMBER |

| TOPOLOGY_ID | VARCHAR2 |

+---------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PARAM_USE

[5 columns]

+---------------------+----------+

| Column | Type |

+---------------------+----------+

| COORD_OP_METHOD_ID | NUMBER |

| LEGACY_PARAM_NAME | VARCHAR2 |

| PARAM_SIGN_REVERSAL | VARCHAR2 |

| PARAMETER_ID | NUMBER |

| SORT_ORDER | NUMBER |

+---------------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_METHODS

[8 columns]

+------------------------+----------+

| Column | Type |

+------------------------+----------+

| COORD_OP_METHOD_ID | NUMBER |

| COORD_OP_METHOD_NAME | VARCHAR2 |

| DATA_SOURCE | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_IMPLEMENTED_FORWARD | NUMBER |

| IS_IMPLEMENTED_REVERSE | NUMBER |

| LEGACY_NAME | VARCHAR2 |

| REVERSE_OP | NUMBER |

+------------------------+----------+

Database: MDSYS

Table: SDO_ST_TOLERANCE

[1 column]

+-----------+--------+

| Column | Type |

+-----------+--------+

| TOLERANCE | NUMBER |

+-----------+--------+

Database: MDSYS

Table: SDO_DATUMS

[16 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| DATUM_ID | NUMBER |

| DATUM_NAME | VARCHAR2 |

| DATUM_TYPE | VARCHAR2 |

| ELLIPSOID_ID | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| PRIME_MERIDIAN_ID | NUMBER |

| ROTATE_X | NUMBER |

| ROTATE_Y | NUMBER |

| ROTATE_Z | NUMBER |

| SCALE_ADJUST | NUMBER |

| SHIFT_X | NUMBER |

| SHIFT_Y | NUMBER |

| SHIFT_Z | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_OPS

[18 columns]

+------------------------+----------+

| Column | Type |

+------------------------+----------+

| COORD_OP_ID | NUMBER |

| COORD_OP_METHOD_ID | NUMBER |

| COORD_OP_NAME | VARCHAR2 |

| COORD_OP_TYPE | VARCHAR2 |

| COORD_OP_VARIANT | NUMBER |

| COORD_TFM_VERSION | VARCHAR2 |

| DATA_SOURCE | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_IMPLEMENTED_FORWARD | NUMBER |

| IS_IMPLEMENTED_REVERSE | NUMBER |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| REVERSE_OP | NUMBER |

| SHOW_OPERATION | NUMBER |

| SOURCE_SRID | NUMBER |

| TARGET_SRID | NUMBER |

| UOM_ID_SOURCE_OFFSETS | NUMBER |

| UOM_ID_TARGET_OFFSETS | NUMBER |

+------------------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PATHS

[5 columns]

+---------------------+--------+

| Column | Type |

+---------------------+--------+

| CONCAT_OPERATION_ID | NUMBER |

| OP_PATH_STEP | NUMBER |

| SINGLE_OP_SOURCE_ID | NUMBER |

| SINGLE_OP_TARGET_ID | NUMBER |

| SINGLE_OPERATION_ID | NUMBER |

+---------------------+--------+

Database: MDSYS

Table: SDO_GR_RDT_1

[8 columns]

+-------------------+--------------+

| Column | Type |

+-------------------+--------------+

| BANDBLOCKNUMBER | NUMBER |

| BLOCKMBR | SDO_GEOMETRY |

| COLUMNBLOCKNUMBER | NUMBER |

| PYRAMIDLEVEL | NUMBER |

| RASTERBLOCK | BLOB |

| RASTERDATATABLE | VARCHAR2 |

| RASTERID | NUMBER |

| ROWBLOCKNUMBER | NUMBER |

+-------------------+--------------+

Database: MDSYS

Table: SDO_GEOR_PLUGIN_REGISTRY

[5 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| COMPANY_NAME | VARCHAR2 |

| DESCRIPTION | VARCHAR2 |

| PLUGIN | VARCHAR2 |

| PLUGIN_NAME | VARCHAR2 |

| PLUGIN_TYPE | VARCHAR2 |

+--------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PARAM_VALS

[8 columns]

+----------------------+----------+

| Column | Type |

+----------------------+----------+

| COORD_OP_ID | NUMBER |

| COORD_OP_METHOD_ID | NUMBER |

| PARAM_VALUE_FILE | CLOB |

| PARAM_VALUE_FILE_REF | VARCHAR2 |

| PARAM_VALUE_XML | XMLTYPE |

| PARAMETER_ID | NUMBER |

| PARAMETER_VALUE | FLOAT |

| UOM_ID | NUMBER |

+----------------------+----------+

Database: MDSYS

Table: SDO_DATUMS_OLD_SNAPSHOT

[8 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| NAME | VARCHAR2 |

| ROTATE_X | NUMBER |

| ROTATE_Y | NUMBER |

| ROTATE_Z | NUMBER |

| SCALE_ADJUST | NUMBER |

| SHIFT_X | NUMBER |

| SHIFT_Y | NUMBER |

| SHIFT_Z | NUMBER |

+--------------+----------+

Database: MDSYS

Table: SDO_PRIME_MERIDIANS

[6 columns]

+---------------------+----------+

| Column | Type |

+---------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| GREENWICH_LONGITUDE | FLOAT |

| INFORMATION_SOURCE | VARCHAR2 |

| PRIME_MERIDIAN_ID | NUMBER |

| PRIME_MERIDIAN_NAME | VARCHAR2 |

| UOM_ID | NUMBER |

+---------------------+----------+

Database: MDSYS

Table: SDO_TOPO_RELATION_DATA

[5 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| TG_ID | NUMBER |

| TG_LAYER_ID | NUMBER |

| TOPO_ATTRIBUTE | VARCHAR2 |

| TOPO_ID | NUMBER |

| TOPO_TYPE | NUMBER |

+----------------+----------+

Database: MDSYS

Table: SDO_PREFERRED_OPS_SYSTEM

[3 columns]

+-------------+--------+

| Column | Type |

+-------------+--------+

| COORD_OP_ID | NUMBER |

| SOURCE_SRID | NUMBER |

| TARGET_SRID | NUMBER |

+-------------+--------+

Database: MDSYS

Table: SDO_COORD_REF_SYS

[18 columns]

+-----------------------+--------------+

| Column | Type |

+-----------------------+--------------+

| CMPD_HORIZ_SRID | NUMBER |

| CMPD_VERT_SRID | NUMBER |

| COORD_REF_SYS_KIND | VARCHAR2 |

| COORD_REF_SYS_NAME | VARCHAR2 |

| COORD_SYS_ID | NUMBER |

| DATA_SOURCE | VARCHAR2 |

| DATUM_ID | NUMBER |

| GEOG_CRS_DATUM_ID | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_LEGACY | VARCHAR2 |

| IS_VALID | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| LEGACY_CS_BOUNDS | SDO_GEOMETRY |

| LEGACY_WKTEXT | VARCHAR2 |

| PROJECTION_CONV_ID | NUMBER |

| SOURCE_GEOG_SRID | NUMBER |

| SRID | NUMBER |

| SUPPORTS_SDO_GEOMETRY | VARCHAR2 |

+-----------------------+--------------+

Database: MDSYS

Table: SDO_TXN_IDX_DELETES

[10 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| END_1 | NUMBER |

| END_2 | NUMBER |

| END_3 | NUMBER |

| END_4 | NUMBER |

| RID | VARCHAR2 |

| SDO_TXN_IDX_ID | VARCHAR2 |

| START_1 | NUMBER |

| START_2 | NUMBER |

| START_3 | NUMBER |

| START_4 | NUMBER |

+----------------+----------+

Database: CTXSYS

Table: DR$OBJECT_ATTRIBUTE

[14 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| OAT_ATT_ID | NUMBER |

| OAT_CLA_ID | NUMBER |

| OAT_DATATYPE | CHAR |

| OAT_DEFAULT | VARCHAR2 |

| OAT_DESC | VARCHAR2 |

| OAT_ID | NUMBER |

| OAT_LOV | CHAR |

| OAT_NAME | VARCHAR2 |

| OAT_OBJ_ID | NUMBER |

| OAT_REQUIRED | CHAR |

| OAT_STATIC | CHAR |

| OAT_SYSTEM | CHAR |

| OAT_VAL_MAX | NUMBER |

| OAT_VAL_MIN | NUMBER |

+--------------+----------+

Database: CTXSYS

Table: DR$NUMBER_SEQUENCE

[1 column]

+--------+--------+

| Column | Type |

+--------+--------+

| NUM | NUMBER |

+--------+--------+

Database: CTXSYS

Table: DR$POLICY_TAB

[2 columns]

+-------------+------+

| Column | Type |

+-------------+------+

| PLT_LANGCOL | CHAR |

| PLT_POLICY | CHAR |

+-------------+------+

Database: SYS

Table: IMPDP_STATS

[25 columns]

+---------+----------+

| Column | Type |

+---------+----------+

| C1 | VARCHAR2 |

| C2 | VARCHAR2 |

| C3 | VARCHAR2 |

| C4 | VARCHAR2 |

| C5 | VARCHAR2 |

| CH1 | VARCHAR2 |

| D1 | DATE |

| FLAGS | NUMBER |

| N1 | NUMBER |

| N10 | NUMBER |

| N11 | NUMBER |

| N12 | NUMBER |

| N2 | NUMBER |

| N3 | NUMBER |

| N4 | NUMBER |

| N5 | NUMBER |

| N6 | NUMBER |

| N7 | NUMBER |

| N8 | NUMBER |

| N9 | NUMBER |

| R1 | RAW |

| R2 | RAW |

| STATID | VARCHAR2 |

| TYPE | CHAR |

| VERSION | NUMBER |

+---------+----------+

Database: SYS

Table: OLAPTABLEVELS

[6 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| CUBE_NAME | VARCHAR2 |

| DIMENSION_NAME | VARCHAR2 |

| DIMENSION_OWNER | VARCHAR2 |

| LEVEL_NAME | VARCHAR2 |

| SCHEMA_NAME | VARCHAR2 |

| SELECTED | NUMBER |

+-----------------+----------+

Database: SYS

Table: AW$AWREPORT

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: ODCI_WARNINGS$

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| C1 | NUMBER |

| C2 | VARCHAR2 |

+--------+----------+

Database: SYS

Table: DUAL

[1 column]

+--------+----------+

| Column | Type |

+--------+----------+

| DUMMY | VARCHAR2 |

+--------+----------+

Database: SYS

Table: OLAP_OLEDB_MDPROPVALS

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| NAME | VARCHAR2 |

| VALUE | NUMBER |

+--------+----------+

Database: SYS

Table: OLAP_OLEDB_FUNCTIONS_PVT

[8 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| CAPTION | VARCHAR2 |

| DESCRIPTION | VARCHAR2 |

| FUNCTION_NAME | VARCHAR2 |

| INTERFACE_NAME | VARCHAR2 |

| OBJECT | VARCHAR2 |

| ORIGIN | NUMBER |

| PARAMETER_LIST | VARCHAR2 |

| RETURN_TYPE | NUMBER |

+----------------+----------+

Database: SYS

Table: AW$EXPRESS

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: AW$AWCREATE10G

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: KU$NOEXP_TAB

[3 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| NAME | VARCHAR2 |

| OBJ_TYPE | VARCHAR2 |

| SCHEMA | VARCHAR2 |

+----------+----------+

Database: SYS

Table: OLAP_OLEDB_KEYWORDS

[1 column]

+---------+----------+

| Column | Type |

+---------+----------+

| KEYWORD | VARCHAR2 |

+---------+----------+

Database: SYS

Table: TABLE_PRIVILEGE_MAP

[2 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| NAME | VARCHAR2 |

| PRIVILEGE | NUMBER |

+-----------+----------+

Database: SYS

Table: PSTUBTBL

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| DBNAME | VARCHAR2 |

| LINE | VARCHAR2 |

| LINENO | NUMBER |

| LUN | VARCHAR2 |

| LUTYPE | VARCHAR2 |

| USERNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: AW$AWCREATE

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: PLAN_TABLE$

[36 columns]

+-------------------+----------+

| Column | Type |

+-------------------+----------+

| ACCESS_PREDICATES | VARCHAR2 |

| BYTES | NUMBER |

| CARDINALITY | NUMBER |

| COST | NUMBER |

| CPU_COST | NUMBER |

| DEPTH | NUMBER |

| DISTRIBUTION | VARCHAR2 |

| FILTER_PREDICATES | VARCHAR2 |

| ID | NUMBER |

| IO_COST | NUMBER |

| OBJECT_ALIAS | VARCHAR2 |

| OBJECT_INSTANCE | NUMBER |

| OBJECT_NAME | VARCHAR2 |

| OBJECT_NODE | VARCHAR2 |

| OBJECT_OWNER | VARCHAR2 |

| OBJECT_TYPE | VARCHAR2 |

| OPERATION | VARCHAR2 |

| OPTIMIZER | VARCHAR2 |

| OPTIONS | VARCHAR2 |

| OTHER | LONG |

| OTHER_TAG | VARCHAR2 |

| OTHER_XML | CLOB |

| PARENT_ID | NUMBER |

| PARTITION_ID | NUMBER |

| PARTITION_START | VARCHAR2 |

| PARTITION_STOP | VARCHAR2 |

| PLAN_ID | NUMBER |

| POSITION | NUMBER |

| PROJECTION | VARCHAR2 |

| QBLOCK_NAME | VARCHAR2 |

| REMARKS | VARCHAR2 |

| SEARCH_COLUMNS | NUMBER |

| STATEMENT_ID | VARCHAR2 |

| TEMP_SPACE | NUMBER |

| TIME | NUMBER |

| TIMESTAMP | DATE |

+-------------------+----------+

Database: SYS

Table: AUDIT_ACTIONS

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| ACTION | NUMBER |

| NAME | VARCHAR2 |

+--------+----------+

Database: SYS

Table: ODCI_SECOBJ$

[4 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| IDXNAME | VARCHAR2 |

| IDXSCHEMA | VARCHAR2 |

| SECOBJNAME | VARCHAR2 |

| SECOBJSCHEMA | VARCHAR2 |

+--------------+----------+

Database: SYS

Table: OLAPTABLEVELTUPLES

[9 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| CUBE_NAME | VARCHAR2 |

| DIMENSION_NAME | VARCHAR2 |

| DIMENSION_OWNER | VARCHAR2 |

| ID | NUMBER |

| LEVEL_NAME | VARCHAR2 |

| PCT_OF_TOTAL | NUMBER |

| ROW_COUNT | NUMBER |

| SCHEMA_NAME | VARCHAR2 |

| SELECTED | NUMBER |

+-----------------+----------+

Database: SYS

Table: OLAP_OLEDB_MDPROPS

[2 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| TYPE | VARCHAR2 |

| VALUE | VARCHAR2 |

+--------+----------+

Database: SYS

Table: WRI$_ADV_ASA_RECO_DATA

[16 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| ALSP | NUMBER |

| BENEFIT_TYPE | NUMBER |

| C1 | VARCHAR2 |

| C2 | VARCHAR2 |

| C3 | VARCHAR2 |

| CHCT | NUMBER |

| CMD_ID | NUMBER |

| CTIME |

| PARTNAME | VARCHAR2 |

| REC | NUMBER |

| SEGNAME | VARCHAR2 |

| SEGOWNER | VARCHAR2 |

| SEGTYPE | VARCHAR2 |

| TASK_ID | NUMBER |

| TSNAME | VARCHAR2 |

| USP | NUMBER |

+--------------+----------+

Database: SYS

Table: KU$_LIST_FILTER_TEMP

[4 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| BASE_PROCESS_ORDER | NUMBER |

| DUPLICATE | NUMBER |

| OBJECT_NAME | VARCHAR2 |

| PROCESS_ORDER | NUMBER |

+--------------------+----------+

Database: SYS

Table: AW$AWXML

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: SYS

Table: STMT_AUDIT_OPTION_MAP

[3 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| "OPTION#" | NUMBER |

| NAME | VARCHAR2 |

| PROPERTY | NUMBER |

+-----------+----------+

Database: SYS

Table: SYSTEM_PRIVILEGE_MAP

[3 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| NAME | VARCHAR2 |

| PRIVILEGE | NUMBER |

| PROPERTY | NUMBER |

+-----------+----------+

Database: SYS

Table: AW$AWMD

[6 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| "GEN#" | NUMBER |

| "PS#" | NUMBER |

| AWLOB | BLOB |

| EXTNUM | NUMBER |

| OBJNAME | VARCHAR2 |

| PARTNAME | VARCHAR2 |

+----------+----------+

Database: IEW_USER

Table: RLM$PARSEDCOND

[3 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| PESEQPOS | NUMBER |

| TAGNAME | VARCHAR2 |

| TAGVALUE | VARCHAR2 |

+----------+----------+

Database: OLAPSYS

Table: OLAP_SESSION_DIMS

[2 columns]

+------------+--------+

| Column | Type |

+------------+--------+

| ID | NUMBER |

| VERSION_ID | CHAR |

+------------+--------+

Database: OLAPSYS

Table: OLAP_SESSION_CUBES

[2 columns]

+------------+--------+

| Column | Type |

+------------+--------+

| ID | NUMBER |

| VERSION_ID | CHAR |

+------------+--------+

Database: SYSTEM

Table: MVIEW$_ADV_PARTITION

[4 columns]

+---------------+----------+

| Column | Type |

+---------------+----------+

| "RANK#" | NUMBER |

| "RUNID#" | NUMBER |

| QUERY_TEXT | LONG |

| SUMMARY_OWNER | VARCHAR2 |

+---------------+----------+

Database: SYSTEM

Table: OL$

[14 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| CATEGORY | VARCHAR2 |

| CREATOR | VARCHAR2 |

| FLAGS | NUMBER |

| HASH_VALUE | NUMBER |

| HASH_VALUE2 | NUMBER |

| HINTCOUNT | NUMBER |

| OL_NAME | VARCHAR2 |

| SIGNATURE | RAW |

| SPARE1 | NUMBER |

| SPARE2 | VARCHAR2 |

| SQL_TEXT | LONG |

| TEXTLEN | NUMBER |

| TIMESTAMP | DATE |

| VERSION | VARCHAR2 |

+-------------+----------+

Database: SYSTEM

Table: HELP

[3 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| INFO | VARCHAR2 |

| SEQ | NUMBER |

| TOPIC | VARCHAR2 |

+--------+----------+

Database: SYSTEM

Table: OL$NODES

[8 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| CATEGORY | VARCHAR2 |

| NODE_ID | NUMBER |

| NODE_NAME | VARCHAR2 |

| NODE_TEXTLEN | NUMBER |

| NODE_TEXTOFF | NUMBER |

| NODE_TYPE | NUMBER |

| OL_NAME | VARCHAR2 |

| PARENT_ID | NUMBER |

+--------------+----------+

Database: SYSTEM

Table: MVIEW$_ADV_OWB

[5 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| "RUNID#" | NUMBER |

| INDEXSCRIPT | CLOB |

| MVSCRIPT | CLOB |

| OBJNAME | VARCHAR2 |

| OWNERNAME | VARCHAR2 |

+-------------+----------+

Database: SYSTEM

Table: DEF$_TEMP$LOB

[3 columns]

+------------+-------+

| Column | Type |

+------------+-------+

| TEMP$BLOB | BLOB |

| TEMP$CLOB | CLOB |

| TEMP$NCLOB | NCLOB |

+------------+-------+

Database: SYSTEM

Table: OL$HINTS

[21 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| "HINT#" | NUMBER |

| "NODE#" | NUMBER |

| "STAGE#" | NUMBER |

| BYTES | FLOAT |

| CARDINALITY | FLOAT |

| CATEGORY | VARCHAR2 |

| COST | FLOAT |

| HINT_STRING | CLOB |

| HINT_TEXT | VARCHAR2 |

| HINT_TEXTLEN | NUMBER |

| HINT_TEXTOFF | NUMBER |

| HINT_TYPE | NUMBER |

| JOIN_PRED | VARCHAR2 |

| OL_NAME | VARCHAR2 |

| REF_ID | NUMBER |

| SPARE1 | NUMBER |

| SPARE2 | NUMBER |

| TABLE_NAME | VARCHAR2 |

| TABLE_POS | NUMBER |

| TABLE_TIN | NUMBER |

| USER_TABLE_NAME | VARCHAR2 |

+-----------------+----------+

Database: SYSTEM

Table: MVIEW$_ADV_INDEX

[8 columns]

+---------------+----------+

| Column | Type |

+---------------+----------+

| "MVINDEX#" | NUMBER |

| "RANK#" | NUMBER |

| "RUNID#" | NUMBER |

| COLUMN_NAME | VARCHAR2 |

| INDEX_CONTENT | VARCHAR2 |

| INDEX_NAME | VARCHAR2 |

| INDEX_TYPE | NUMBER |

| SUMMARY_OWNER | VARCHAR2 |

+---------------+----------+

Database: IEW

Table: USER_REF

[6 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| CREATED_DATE | DATE |

| USER_EMAIL | VARCHAR2 |

| USER_ID | NUMBER |

| USER_NAME | VARCHAR2 |

| USER_PASS | VARCHAR2 |

| USER_ROLE_ID | NUMBER |

+--------------+----------+

Database: IEW

Table: ORG_TYPE_REF

[5 columns]

+-----------------------+----------+

| Column | Type |

+-----------------------+----------+

| ORG_TYPE_ID | NUMBER |

| ORG_TYPE_NAME | VARCHAR2 |

| ORG_TYPE_NAME_DISPLAY | VARCHAR2 |

| ORG_TYPE_NAME_SHORT | VARCHAR2 |

| SORT_PRIORITY | NUMBER |

+-----------------------+----------+

Database: IEW

Table: CUSTOM_PAGE_REF

[7 columns]

+----------------------+----------+

| Column | Type |

+----------------------+----------+

| CNTRY_CODE | VARCHAR2 |

| CREATED_DATE | DATE |

| CUSTOM_PAGE_ID | NUMBER |

| CUSTOM_PAGE_NAME | VARCHAR2 |

| CUSTOM_PAGE_TEMPLATE | VARCHAR2 |

| REGION_CODE | VARCHAR2 |

| STATE_CODE | VARCHAR2 |

+----------------------+----------+

Database: IEW

Table: STATE_REF

[2 columns]

+------------+----------+

| Column | Type |

+------------+----------+

| STATE_CODE | VARCHAR2 |

| STATE_NAME | VARCHAR2 |

+------------+----------+

Database: IEW

Table: EVENTS_REF

[27 columns]

+-----------------------+----------+

| Column | Type |

+-----------------------+----------+

| CONTACT_EMAIL | VARCHAR2 |

| CONTACT_NAME | VARCHAR2 |

| CONTACT_TITLE | VARCHAR2 |

| CREATE_USER_ID | NUMBER |

| CREATED_DATE | DATE |

| EVENT_CITY | VARCHAR2 |

| EVENT_CNTRY_CODE | VARCHAR2 |

| EVENT_DESC | VARCHAR2 |

| EVENT_DESC_LONG | CLOB |

| EVENT_EMAIL | VARCHAR2 |

| EVENT_END_DATE | DATE |

| EVENT_END_DATE_MASK | VARCHAR2 |

| EVENT_ID | NUMBER |

| EVENT_LOC | VARCHAR2 |

| EVENT_ORG_NAME | VARCHAR2 |

| EVENT_START_DATE | DATE |

| EVENT_START_DATE_MASK | VARCHAR2 |

| EVENT_STATE_CODE | VARCHAR2 |

| EVENT_URL | VARCHAR2 |

| EVENT_YEAR | VARCHAR2 |

| IS_APPROVED | NUMBER |

| ORG_TYPE_ID | NUMBER |

| TOKEN | VARCHAR2 |

| UPDATE_DATE | DATE |

| UPDATE_USER_ID | NUMBER |

| WEB_DATE | DATE |

| WEB_USER_ID | NUMBER |

+-----------------------+----------+

Database: IEW

Table: CNTRY_REF

[2 columns]

+------------+----------+

| Column | Type |

+------------+----------+

| CNTRY_CODE | VARCHAR2 |

| CNTRY_NAME | VARCHAR2 |

+------------+----------+

Database: IEW

Table: REGION_REF

[2 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| REGION_CODE | VARCHAR2 |

| REGION_NAME | VARCHAR2 |

+-------------+----------+

Database: IEW

Table: CNTRY_TO_REGION

[2 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| CNTRY_CODE | VARCHAR2 |

| REGION_CODE | VARCHAR2 |

+-------------+----------+

Database: IEW

Table: EVENTS_TO_CUSTOM_PAGE

[4 columns]

+----------------+--------+

| Column | Type |

+----------------+--------+

| CREATED_DATE | DATE |

| CUSTOM_PAGE_ID | NUMBER |

| EVENT_ID | NUMBER |

| USER_ID | NUMBER |

+----------------+--------+

Database: IEW

Table: EVENT_REPORT_REF

[7 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| EVENT_ID | NUMBER |

| IS_APPROVED | NUMBER |

| REPORT_DATE | DATE |

| REPORT_HTML | VARCHAR2 |

| REPORT_ID | NUMBER |

| REPORT_NOTES | VARCHAR2 |

| REPORT_SRC | VARCHAR2 |

+--------------+----------+

Database: IEW

Table: EVENT_PHOTO_REF

[8 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| EVENT_ID | NUMBER |

| IS_APPROVED | NUMBER |

| PHOTO_CREDIT | VARCHAR2 |

| PHOTO_DATE | DATE |

| PHOTO_DESC | VARCHAR2 |

| PHOTO_ID | NUMBER |

| PHOTO_SRC | VARCHAR2 |

| SUBMIT_DATE | DATE |

+--------------+----------+

Database: IEW

Table: USER_ROLE_REF

[6 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| ACCESS_LEVEL | NUMBER |

| CREATED_DATE | DATE |

| CUSTOM_PAGE_ID | NUMBER |

| IS_READONLY | NUMBER |

| USER_ROLE_ID | NUMBER |

| USER_ROLE_NAME | VARCHAR2 |

+----------------+----------+

Database: EXFSYS

Table: RLM$PARSEDCOND

[3 columns]

+----------+----------+

| Column | Type |

+----------+----------+

| PESEQPOS | NUMBER |

| TAGNAME | VARCHAR2 |

| TAGVALUE | VARCHAR2 |

+----------+----------+

Database: MDSYS

Table: SDO_COORD_SYS

[6 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| COORD_SYS_ID | NUMBER |

| COORD_SYS_NAME | VARCHAR2 |

| COORD_SYS_TYPE | VARCHAR2 |

| DATA_SOURCE | VARCHAR2 |

| DIMENSION | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PARAMS

[4 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| PARAMETER_ID | NUMBER |

| PARAMETER_NAME | VARCHAR2 |

+--------------------+----------+

Database: MDSYS

Table: OGIS_SPATIAL_REFERENCE_SYSTEMS

[5 columns]

+-----------+----------+

| Column | Type |

+-----------+----------+

| AUTH_NAME | VARCHAR2 |

| AUTH_SRID | NUMBER |

| SRID | NUMBER |

| SRNUM | NUMBER |

| SRTEXT | VARCHAR2 |

+-----------+----------+

Database: MDSYS

Table: SDO_GR_MOSAIC_0

[27 columns]

+--------+----------+

| Column | Type |

+--------+----------+

| B0 | NUMBER |

| B1 | NUMBER |

| BANDS | NUMBER |

| BBLKSZ | NUMBER |

| BCV | NUMBER |

| C0 | NUMBER |

| C1 | NUMBER |

| CBLKSZ | NUMBER |

| CDL | NUMBER |

| CDP | VARCHAR2 |

| COLS | NUMBER |

| CPTYPE | VARCHAR2 |

| ILV | VARCHAR2 |

| META | XMLTYPE |

| R0 | NUMBER |

| R1 | NUMBER |

| RBLKSZ | NUMBER |

| RCTIF | VARCHAR2 |

| RDT | VARCHAR2 |

| RID | ROWID |

| RROWS | NUMBER |

| RSTID | NUMBER |

| RSTYPE | NUMBER |

| SRID | NUMBER |

| ULTB | NUMBER |

| ULTC | NUMBER |

| ULTR | NUMBER |

+--------+----------+

Database: MDSYS

Table: SDO_GR_MOSAIC_3

[1 column]

+--------+--------+

| Column | Type |

+--------+--------+

| P | NUMBER |

+--------+--------+

Database: MDSYS

Table: SDO_GR_MOSAIC_2

[11 columns]

+--------+--------+

| Column | Type |

+--------+--------+

| B0 | NUMBER |

| B1 | NUMBER |

| C0 | NUMBER |

| C1 | NUMBER |

| CSIZE | NUMBER |

| R0 | NUMBER |

| R1 | NUMBER |

| RID | ROWID |

| RSIZE | NUMBER |

| ULTC | NUMBER |

| ULTR | NUMBER |

+--------+--------+

Database: MDSYS

Table: SDO_TXN_IDX_EXP_UPD_RGN

[10 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| END_1 | NUMBER |

| END_2 | NUMBER |

| END_3 | NUMBER |

| END_4 | NUMBER |

| RID | VARCHAR2 |

| SDO_TXN_IDX_ID | VARCHAR2 |

| START_1 | NUMBER |

| START_2 | NUMBER |

| START_3 | NUMBER |

| START_4 | NUMBER |

+----------------+----------+

Database: MDSYS

Table: SDO_XML_SCHEMAS

[3 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| DESCRIPTION | VARCHAR2 |

| ID | NUMBER |

| XMLSCHEMA | CLOB |

+-------------+----------+

Database: MDSYS

Table: SDO_GEOR_XMLSCHEMA_TABLE

[3 columns]

+-----------------+----------+

| Column | Type |

+-----------------+----------+

| GEORASTERFORMAT | VARCHAR2 |

| ID | NUMBER |

| XMLSCHEMA | CLOB |

+-----------------+----------+

Database: MDSYS

Table: SDO_TXN_IDX_INSERTS

[10 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| END_1 | NUMBER |

| END_2 | NUMBER |

| END_3 | NUMBER |

| END_4 | NUMBER |

| RID | VARCHAR2 |

| SDO_TXN_IDX_ID | VARCHAR2 |

| START_1 | NUMBER |

| START_2 | NUMBER |

| START_3 | NUMBER |

| START_4 | NUMBER |

+----------------+----------+

Database: MDSYS

Table: OGIS_GEOMETRY_COLUMNS

[10 columns]

+-------------------+----------+

| Column | Type |

+-------------------+----------+

| COORD_DIMENSION | NUMBER |

| F_GEOMETRY_COLUMN | VARCHAR2 |

| F_TABLE_NAME | VARCHAR2 |

| F_TABLE_SCHEMA | VARCHAR2 |

| G_TABLE_NAME | VARCHAR2 |

| G_TABLE_SCHEMA | VARCHAR2 |

| GEOMETRY_TYPE | NUMBER |

| MAX_PPR | NUMBER |

| SRID | NUMBER |

| STORAGE_TYPE | NUMBER |

+-------------------+----------+

Database: MDSYS

Table: SDO_ELLIPSOIDS_OLD_SNAPSHOT

[3 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| INVERSE_FLATTENING | NUMBER |

| NAME | VARCHAR2 |

| SEMI_MAJOR_AXIS | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_AXES

[6 columns]

+-------------------------+----------+

| Column | Type |

+-------------------------+----------+

| COORD_AXIS_ABBREVIATION | VARCHAR2 |

| COORD_AXIS_NAME_ID | NUMBER |

| COORD_AXIS_ORIENTATION | VARCHAR2 |

| COORD_SYS_ID | NUMBER |

| ORDER | NUMBER |

| UOM_ID | NUMBER |

+-------------------------+----------+

Database: MDSYS

Table: SDO_CS_SRS

[6 columns]

+-----------+--------------+

| Column | Type |

+-----------+--------------+

| AUTH_NAME | VARCHAR2 |

| AUTH_SRID | NUMBER |

| CS_BOUNDS | SDO_GEOMETRY |

| CS_NAME | VARCHAR2 |

| SRID | NUMBER |

| WKTEXT | VARCHAR2 |

+-----------+--------------+

Database: MDSYS

Table: SDO_UNITS_OF_MEASURE

[12 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| FACTOR_B | NUMBER |

| FACTOR_C | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| LEGACY_UNIT_NAME | VARCHAR2 |

| SHORT_NAME | VARCHAR2 |

| TARGET_UOM_ID | NUMBER |

| UNIT_OF_MEAS_NAME | VARCHAR2 |

| UNIT_OF_MEAS_TYPE | VARCHAR2 |

| UOM_ID | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_AXIS_NAMES

[2 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| COORD_AXIS_NAME | VARCHAR2 |

| COORD_AXIS_NAME_ID | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_GR_MOSAIC_1

[11 columns]

+--------+--------+

| Column | Type |

+--------+--------+

| B0 | NUMBER |

| B1 | NUMBER |

| C0 | NUMBER |

| C1 | NUMBER |

| CSIZE | NUMBER |

| R0 | NUMBER |

| R1 | NUMBER |

| RID | ROWID |

| RSIZE | NUMBER |

| ULTC | NUMBER |

| ULTR | NUMBER |

+--------+--------+

Database: MDSYS

Table: SDO_ELLIPSOIDS

[10 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| ELLIPSOID_ID | NUMBER |

| ELLIPSOID_NAME | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| INV_FLATTENING | NUMBER |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| SEMI_MAJOR_AXIS | NUMBER |

| SEMI_MINOR_AXIS | NUMBER |

| UOM_ID | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_PREFERRED_OPS_USER

[4 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| COORD_OP_ID | NUMBER |

| SOURCE_SRID | NUMBER |

| TARGET_SRID | NUMBER |

| USE_CASE | VARCHAR2 |

+-------------+----------+

Database: MDSYS

Table: SDO_TOPO_DATA$

[5 columns]

+-------------+----------+

| Column | Type |

+-------------+----------+

| TG_ID | NUMBER |

| TG_LAYER_ID | NUMBER |

| TOPO_ID | NUMBER |

| TOPO_TYPE | NUMBER |

| TOPOLOGY | VARCHAR2 |

+-------------+----------+

Database: MDSYS

Table: SDO_PROJECTIONS_OLD_SNAPSHOT

[1 column]

+--------+----------+

| Column | Type |

+--------+----------+

| NAME | VARCHAR2 |

+--------+----------+

Database: MDSYS

Table: SDO_TOPO_TRANSACT_DATA

[6 columns]

+---------------+----------+

| Column | Type |

+---------------+----------+

| PARENT_ID | NUMBER |

| TOPO_ID | NUMBER |

| TOPO_OP | VARCHAR2 |

| TOPO_SEQUENCE | NUMBER |

| TOPO_TYPE | NUMBER |

| TOPOLOGY_ID | VARCHAR2 |

+---------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PARAM_USE

[5 columns]

+---------------------+----------+

| Column | Type |

+---------------------+----------+

| COORD_OP_METHOD_ID | NUMBER |

| LEGACY_PARAM_NAME | VARCHAR2 |

| PARAM_SIGN_REVERSAL | VARCHAR2 |

| PARAMETER_ID | NUMBER |

| SORT_ORDER | NUMBER |

+---------------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_METHODS

[8 columns]

+------------------------+----------+

| Column | Type |

+------------------------+----------+

| COORD_OP_METHOD_ID | NUMBER |

| COORD_OP_METHOD_NAME | VARCHAR2 |

| DATA_SOURCE | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_IMPLEMENTED_FORWARD | NUMBER |

| IS_IMPLEMENTED_REVERSE | NUMBER |

| LEGACY_NAME | VARCHAR2 |

| REVERSE_OP | NUMBER |

+------------------------+----------+

Database: MDSYS

Table: SDO_ST_TOLERANCE

[1 column]

+-----------+--------+

| Column | Type |

+-----------+--------+

| TOLERANCE | NUMBER |

+-----------+--------+

Database: MDSYS

Table: SDO_DATUMS

[16 columns]

+--------------------+----------+

| Column | Type |

+--------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| DATUM_ID | NUMBER |

| DATUM_NAME | VARCHAR2 |

| DATUM_TYPE | VARCHAR2 |

| ELLIPSOID_ID | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| PRIME_MERIDIAN_ID | NUMBER |

| ROTATE_X | NUMBER |

| ROTATE_Y | NUMBER |

| ROTATE_Z | NUMBER |

| SCALE_ADJUST | NUMBER |

| SHIFT_X | NUMBER |

| SHIFT_Y | NUMBER |

| SHIFT_Z | NUMBER |

+--------------------+----------+

Database: MDSYS

Table: SDO_COORD_OPS

[18 columns]

+------------------------+----------+

| Column | Type |

+------------------------+----------+

| COORD_OP_ID | NUMBER |

| COORD_OP_METHOD_ID | NUMBER |

| COORD_OP_NAME | VARCHAR2 |

| COORD_OP_TYPE | VARCHAR2 |

| COORD_OP_VARIANT | NUMBER |

| COORD_TFM_VERSION | VARCHAR2 |

| DATA_SOURCE | VARCHAR2 |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_IMPLEMENTED_FORWARD | NUMBER |

| IS_IMPLEMENTED_REVERSE | NUMBER |

| IS_LEGACY | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| REVERSE_OP | NUMBER |

| SHOW_OPERATION | NUMBER |

| SOURCE_SRID | NUMBER |

| TARGET_SRID | NUMBER |

| UOM_ID_SOURCE_OFFSETS | NUMBER |

| UOM_ID_TARGET_OFFSETS | NUMBER |

+------------------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PATHS

[5 columns]

+---------------------+--------+

| Column | Type |

+---------------------+--------+

| CONCAT_OPERATION_ID | NUMBER |

| OP_PATH_STEP | NUMBER |

| SINGLE_OP_SOURCE_ID | NUMBER |

| SINGLE_OP_TARGET_ID | NUMBER |

| SINGLE_OPERATION_ID | NUMBER |

+---------------------+--------+

Database: MDSYS

Table: SDO_GR_RDT_1

[8 columns]

+-------------------+--------------+

| Column | Type |

+-------------------+--------------+

| BANDBLOCKNUMBER | NUMBER |

| BLOCKMBR | SDO_GEOMETRY |

| COLUMNBLOCKNUMBER | NUMBER |

| PYRAMIDLEVEL | NUMBER |

| RASTERBLOCK | BLOB |

| RASTERDATATABLE | VARCHAR2 |

| RASTERID | NUMBER |

| ROWBLOCKNUMBER | NUMBER |

+-------------------+--------------+

Database: MDSYS

Table: SDO_GEOR_PLUGIN_REGISTRY

[5 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| COMPANY_NAME | VARCHAR2 |

| DESCRIPTION | VARCHAR2 |

| PLUGIN | VARCHAR2 |

| PLUGIN_NAME | VARCHAR2 |

| PLUGIN_TYPE | VARCHAR2 |

+--------------+----------+

Database: MDSYS

Table: SDO_COORD_OP_PARAM_VALS

[8 columns]

+----------------------+----------+

| Column | Type |

+----------------------+----------+

| COORD_OP_ID | NUMBER |

| COORD_OP_METHOD_ID | NUMBER |

| PARAM_VALUE_FILE | CLOB |

| PARAM_VALUE_FILE_REF | VARCHAR2 |

| PARAM_VALUE_XML | XMLTYPE |

| PARAMETER_ID | NUMBER |

| PARAMETER_VALUE | FLOAT |

| UOM_ID | NUMBER |

+----------------------+----------+

Database: MDSYS

Table: SDO_DATUMS_OLD_SNAPSHOT

[8 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| NAME | VARCHAR2 |

| ROTATE_X | NUMBER |

| ROTATE_Y | NUMBER |

| ROTATE_Z | NUMBER |

| SCALE_ADJUST | NUMBER |

| SHIFT_X | NUMBER |

| SHIFT_Y | NUMBER |

| SHIFT_Z | NUMBER |

+--------------+----------+

Database: MDSYS

Table: SDO_PRIME_MERIDIANS

[6 columns]

+---------------------+----------+

| Column | Type |

+---------------------+----------+

| DATA_SOURCE | VARCHAR2 |

| GREENWICH_LONGITUDE | FLOAT |

| INFORMATION_SOURCE | VARCHAR2 |

| PRIME_MERIDIAN_ID | NUMBER |

| PRIME_MERIDIAN_NAME | VARCHAR2 |

| UOM_ID | NUMBER |

+---------------------+----------+

Database: MDSYS

Table: SDO_TOPO_RELATION_DATA

[5 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| TG_ID | NUMBER |

| TG_LAYER_ID | NUMBER |

| TOPO_ATTRIBUTE | VARCHAR2 |

| TOPO_ID | NUMBER |

| TOPO_TYPE | NUMBER |

+----------------+----------+

Database: MDSYS

Table: SDO_PREFERRED_OPS_SYSTEM

[3 columns]

+-------------+--------+

| Column | Type |

+-------------+--------+

| COORD_OP_ID | NUMBER |

| SOURCE_SRID | NUMBER |

| TARGET_SRID | NUMBER |

+-------------+--------+

Database: MDSYS

Table: SDO_COORD_REF_SYS

[18 columns]

+-----------------------+--------------+

| Column | Type |

+-----------------------+--------------+

| CMPD_HORIZ_SRID | NUMBER |

| CMPD_VERT_SRID | NUMBER |

| COORD_REF_SYS_KIND | VARCHAR2 |

| COORD_REF_SYS_NAME | VARCHAR2 |

| COORD_SYS_ID | NUMBER |

| DATA_SOURCE | VARCHAR2 |

| DATUM_ID | NUMBER |

| GEOG_CRS_DATUM_ID | NUMBER |

| INFORMATION_SOURCE | VARCHAR2 |

| IS_LEGACY | VARCHAR2 |

| IS_VALID | VARCHAR2 |

| LEGACY_CODE | NUMBER |

| LEGACY_CS_BOUNDS | SDO_GEOMETRY |

| LEGACY_WKTEXT | VARCHAR2 |

| PROJECTION_CONV_ID | NUMBER |

| SOURCE_GEOG_SRID | NUMBER |

| SRID | NUMBER |

| SUPPORTS_SDO_GEOMETRY | VARCHAR2 |

+-----------------------+--------------+

Database: MDSYS

Table: SDO_TXN_IDX_DELETES

[10 columns]

+----------------+----------+

| Column | Type |

+----------------+----------+

| END_1 | NUMBER |

| END_2 | NUMBER |

| END_3 | NUMBER |

| END_4 | NUMBER |

| RID | VARCHAR2 |

| SDO_TXN_IDX_ID | VARCHAR2 |

| START_1 | NUMBER |

| START_2 | NUMBER |

| START_3 | NUMBER |

| START_4 | NUMBER |

+----------------+----------+

Database: CTXSYS

Table: DR$OBJECT_ATTRIBUTE

[14 columns]

+--------------+----------+

| Column | Type |

+--------------+----------+

| OAT_ATT_ID | NUMBER |

| OAT_CLA_ID | NUMBER |

| OAT_DATATYPE | CHAR |

| OAT_DEFAULT | VARCHAR2 |

| OAT_DESC | VARCHAR2 |

| OAT_ID | NUMBER |

| OAT_LOV | CHAR |

| OAT_NAME | VARCHAR2 |

| OAT_OBJ_ID | NUMBER |

| OAT_REQUIRED | CHAR |

| OAT_STATIC | CHAR |

| OAT_SYSTEM | CHAR |

| OAT_VAL_MAX | NUMBER |

| OAT_VAL_MIN | NUMBER |

+--------------+----------+

Database: CTXSYS

Table: DR$NUMBER_SEQUENCE

[1 column]

+--------+--------+

| Column | Type |

+--------+--------+

| NUM | NUMBER |

+--------+--------+

Database: CTXSYS

Table: DR$POLICY_TAB

[2 columns]

+-------------+------+

| Column | Type |

+-------------+------+

| PLT_LANGCOL | CHAR |

| PLT_POLICY | CHAR |