Mac下使用Docker制作Oralce 12c镜像

2016-12-26 09:27:52来源:作者:Elton's Blog人点击

第七城市

#Mac下使用Docker制作Oralce 12c镜像

##安装Docker

在 官网 下载最新版的Docker for Mac,安装好以后,使用下面命令测试

$ docker --versionDocker version 1.12.5, build 7392c3b$ docker run -d -p 80:80 --name webserver nginx

在浏览器中使用 http://localhost/ 查看,如果安装正确,将显示如下界面。

##制作镜像

###下载制作镜像要用的代码

$git clone https://github.com/wscherphof/oracle-12c

###下载Oracle数据库

####第一步 1. 从 Oracle Tech Net 下载 linuxamd64_12102_database_1of2.zip & linuxamd64_12102_database_2of2.zip 2. 把两个zip文件放到 step1 目录中 3. 进入 cd oracle-12c 目录 4. $ docker build -t oracle-12c:step1 step1 5. $ docker run --shm-size=4g -ti --name step1 oracle-12c:step1 /bin/bash 6. # /tmp/install/install (大约5分钟)

``Tue Sep 16 08:48:00 UTC 2014Starting Oracle Universal Installer...Checking Temp space: must be greater than 500 MB. Actual 40142 MB PassedChecking swap space: must be greater than 150 MB. Actual 1392 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-16_08-48-01AM. Please wait ...[root@51905aa48207 /]# You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2014-09-16_08-48-01AM.logThe installation of Oracle Database 12c was successful.Please check '/u01/app/oraInventory/logs/silentInstall2014-09-16_08-48-01AM.log' for more details.As a root user, execute the following script(s): 1. /u01/app/oracle/product/12.1.0/dbhome_1/root.shSuccessfully Setup Software.As install user, execute the following script to complete the configuration. 1. /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file> Note: 1. This script must be run on the same host from where installer was run. 2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).``` <enter> # exit $ docker commit step1 oracle-12c:installed

####第二步 1. $ docker build -t oracle-12c:step2 step2 2. $ docker run --shm-size=4g -ti --name step2 oracle-12c:step2 /bin/bash 3. # /tmp/create (大约需要15分钟)

``Tue Sep 16 11:07:30 UTC 2014Creating database...SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 16 11:07:30 2014Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to an idle instance.File created.ORACLE instance started.Total System Global Area 1073741824 bytesFixed Size 2932632 bytesVariable Size 721420392 bytesDatabase Buffers 343932928 bytesRedo Buffers 5455872 bytesDatabase created.Tablespace created.Tablespace created.Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsTue Sep 16 11:07:50 UTC 2014Creating password file...Tue Sep 16 11:07:50 UTC 2014Running catalog.sql...Tue Sep 16 11:08:51 UTC 2014Running catproc.sql...Tue Sep 16 11:19:38 UTC 2014Running pupbld.sql...Tue Sep 16 11:19:38 UTC 2014Create is done; commit the container now``` # exit $ docker commit step2 oracle-12c:created

####第三步 1. $ docker build -t oracle-12c step3 之后就生成了一个名为oracle-12c的docker image了,这时候可以把其他的中间使用的image都删掉了。

$ docker imagesREPOSITORY TAG IMAGE ID CREATED SIZEoracle-12c latest 17c7e6958ec3 12 hours ago 14.73 GBwscherphof/oracle-linux-7 latest a07f8cc9627f 2 years ago 437.4 MB

###运行

$ docker run --shm-size=4g -dP --name orcl oracle-12c989f1b41b1f00c53576ab85e773b60f2458a75c108c12d4ac3d70be4e801b563 默认密码 username password sys change_on_install system manager

ORCL 数据库端口是 1521 , 通过下面的命令,可以查找主机的端口

$ docker port orcl 15210.0.0.0:32770

这样就可以使用 sqlplus [^1] 的命令连接Oracle

[^1]: 安装 sqlplus 。从Oracle网站下载Mac版本的 客户端 。下载 instantclient-basic-macos.x64-12.1.0.2.0.zip 和 instantclient-sqlplus-macos.x64-12.1.0.2.0.zip ,把它们都解压到如 instantclient_12_1 的目录中。进入 cd ~/instantclient_12_1 目录, ln -s libclntsh.dylib.12.1 libclntsh.dylib , ln -s libocci.dylib.12.1 libocci.dylib ,设置环境变量 export PATH=~/instantclient_12_1:$PATH

$ sqlplus system/manager@localhost:32770/orclSQL*Plus: Release 12.1.0.2.0 Production on Sun Dec 25 00:32:23 2016Copyright (c) 1982, 2016, Oracle. All rights reserved.Last Successful login time: Sat Dec 24 2016 23:25:27 +08:00Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL>

###进入容器 如果想进入容器进行操作,可以使用下面的命令:

docker exec -it orcl /bin/bash

###安装Sample数据库 默认情况下,sample数据库和对应的用户都没有创建。

# 进入容器$ docker exec -it orcl /bin/bash#安装git$ yum install git#进入demo schema目录$ cd /u01/app/oracle/product/12.1.0/dbhome_1/demo/schema/#下载Sample schema$ git clone https://github.com/oracle/db-sample-schemas.git .#替换下载脚本中的目录$ perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat#创建log目录$ mkdir log#更改权限$ chown -R oracle:oinstall .#连接数据库$ sqlplus sys/change_on_install@localhost/orcl as sysdb#执行安装脚本#格式为SQL> @?/demo/schema/mksample <SYSTEM_password> <SYS_password> <HR_password> <OE_password> <PM_password> <IX_password> <SH_password> <BI_password> EXAMPLE TEMP $ORACLE_HOME/demo/schema/log/ localhost:1521/pdbSQL> @?/demo/schema/mksample manager change_on_install hr oe pm ix sh bi users temp $ORACLE_HOME/demo/schema/log/ localhost:1521/orcl#最后可以看到执行结果All named objects and statiOWNER OBJECT_TYPE OBJECT_NAME SUBOBJECT_NAME STATUS------ -------------------- ------------------------------ ---------------- --------BI SYNONYM CHANNELS VALIDBI SYNONYM COSTS VALIDBI SYNONYM COUNTRIES VALIDBI SYNONYM CUSTOMERS VALIDBI SYNONYM PRODUCTS VALIDBI SYNONYM PROMOTIONS VALIDBI SYNONYM SALES VALIDBI SYNONYM TIMES VALIDHR INDEX COUNTRY_C_ID_PK VALIDHR INDEX DEPT_ID_PK VALIDHR INDEX DEPT_LOCATION_IX VALIDHR INDEX EMP_DEPARTMENT_IX VALIDHR INDEX EMP_EMAIL_UK VALIDHR INDEX EMP_EMP_ID_PK VALIDHR INDEX EMP_JOB_IX VALIDHR INDEX EMP_MANAGER_IX VALIDHR INDEX EMP_NAME_IX VALIDHR INDEX JHIST_DEPARTMENT_IX VALIDHR INDEX JHIST_EMPLOYEE_IX VALIDHR INDEX JHIST_EMP_ID_ST_DATE_PK VALIDHR INDEX JHIST_JOB_IX VALIDHR INDEX JOB_ID_PK VALIDHR INDEX LOC_CITY_IX VALIDHR INDEX LOC_COUNTRY_IX VALIDHR INDEX LOC_ID_PK VALIDHR INDEX LOC_STATE_PROVINCE_IX VALIDHR INDEX REG_ID_PK VALIDHR PROCEDURE ADD_JOB_HISTORY VALIDHR PROCEDURE SECURE_DML VALIDHR SEQUENCE DEPARTMENTS_SEQ VALIDHR SEQUENCE EMPLOYEES_SEQ VALIDHR SEQUENCE LOCATIONS_SEQ VALIDHR TABLE COUNTRIES VALIDHR TABLE DEPARTMENTS VALIDHR TABLE EMPLOYEES VALIDHR TABLE JOBS VALIDHR TABLE JOB_HISTORY VALIDHR TABLE LOCATIONS VALIDHR TABLE REGIONS VALIDHR TRIGGER SECURE_EMPLOYEES VALIDHR TRIGGER UPDATE_JOB_HISTORY VALIDHR VIEW EMP_DETAILS_VIEW VALIDIX EVALUATION CONTEXT AQ$_ORDERS_QUEUETABLE_V VALIDIX EVALUATION CONTEXT AQ$_STREAMS_QUEUE_TABLE_V VALIDIX INDEX AQ$_STREAMS_QUEUE_TABLE_Y VALIDIX QUEUE AQ$_ORDERS_QUEUETABLE_E VALIDIX QUEUE AQ$_STREAMS_QUEUE_TABLE_E VALIDIX QUEUE ORDERS_QUEUE VALIDIX QUEUE STREAMS_QUEUE VALIDIX RULE SET ORDERS_QUEUE_N VALIDIX RULE SET ORDERS_QUEUE_R VALIDIX RULE SET STREAMS_QUEUE_N VALIDIX RULE SET STREAMS_QUEUE_R VALIDIX SEQUENCE AQ$_ORDERS_QUEUETABLE_N VALIDIX SEQUENCE AQ$_STREAMS_QUEUE_TABLE_N VALIDIX TABLE AQ$_ORDERS_QUEUETABLE_G VALIDIX TABLE AQ$_ORDERS_QUEUETABLE_H VALIDIX TABLE AQ$_ORDERS_QUEUETABLE_I VALIDIX TABLE AQ$_ORDERS_QUEUETABLE_L VALIDIX TABLE AQ$_ORDERS_QUEUETABLE_S VALIDIX TABLE AQ$_ORDERS_QUEUETABLE_T VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_C VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_G VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_H VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_I VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_L VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_S VALIDIX TABLE AQ$_STREAMS_QUEUE_TABLE_T VALIDIX TABLE ORDERS_QUEUETABLE VALIDIX TABLE STREAMS_QUEUE_TABLE VALIDIX TYPE ORDER_EVENT_TYP VALIDIX VIEW AQ$ORDERS_QUEUETABLE VALIDIX VIEW AQ$ORDERS_QUEUETABLE_R VALIDIX VIEW AQ$ORDERS_QUEUETABLE_S VALIDIX VIEW AQ$STREAMS_QUEUE_TABLE VALIDIX VIEW AQ$STREAMS_QUEUE_TABLE_R VALIDIX VIEW AQ$STREAMS_QUEUE_TABLE_S VALIDIX VIEW AQ$_ORDERS_QUEUETABLE_F VALIDIX VIEW AQ$_STREAMS_QUEUE_TABLE_F VALIDOE FUNCTION GET_PHONE_NUMBER_F VALIDOE INDEX ACTION_TABLE_MEMBERS VALIDOE INDEX INVENTORY_IX VALIDOE INDEX INV_PRODUCT_IX VALIDOE INDEX ITEM_ORDER_IX VALIDOE INDEX ITEM_PRODUCT_IX VALIDOE INDEX LINEITEM_TABLE_MEMBERS VALIDOE INDEX ORDER_ITEMS_PK VALIDOE INDEX ORDER_ITEMS_UK VALIDOE INDEX ORDER_PK VALIDOE INDEX ORD_CUSTOMER_IX VALIDOE INDEX ORD_ORDER_DATE_IX VALIDOE INDEX ORD_SALES_REP_IX VALIDOE INDEX PRD_DESC_PK VALIDOE INDEX PRODUCT_INFORMATION_PK VALIDOE INDEX PROD_NAME_IX VALIDOE INDEX PROD_SUPPLIER_IX VALIDOE INDEX PROMO_ID_PK VALIDOE LOB EXTRADATA206_L VALIDOE LOB NAMESPACES207_L VALIDOE SEQUENCE ORDERS_SEQ VALIDOE SYNONYM COUNTRIES VALIDOE SYNONYM DEPARTMENTS VALIDOE SYNONYM EMPLOYEES VALIDOE SYNONYM JOBS VALIDOE SYNONYM JOB_HISTORY VALIDOE SYNONYM LOCATIONS VALIDOE TABLE ACTION_TABLE VALIDOE TABLE CATEGORIES_TAB VALIDOE TABLE INVENTORIES VALIDOE TABLE LINEITEM_TABLE VALIDOE TABLE ORDERS VALIDOE TABLE ORDER_ITEMS VALIDOE TABLE PRODUCT_DESCRIPTIONS VALIDOE TABLE PRODUCT_INFORMATION VALIDOE TABLE PRODUCT_REF_LIST_NESTEDTAB VALIDOE TABLE PROMOTIONS VALIDOE TABLE PURCHASEORDER VALIDOE TABLE SUBCATEGORY_REF_LIST_NESTEDTAB VALIDOE TRIGGER INSERT_ORD_LINE VALIDOE TRIGGER PURCHASEORDER$xd VALIDOE TYPE ACTIONS_T VALIDOE TYPE ACTION_T VALIDOE TYPE ACTION_V VALIDOE TYPE CATALOG_TYP $VSN_1 VALIDOE TYPE CATALOG_TYP VALIDOE TYPE CATEGORY_TYP $VSN_1 VALIDOE TYPE CATEGORY_TYP VALIDOE TYPE COMPOSITE_CATEGORY_TYP $VSN_1 VALIDOE TYPE COMPOSITE_CATEGORY_TYP VALIDOE TYPE CORPORATE_CUSTOMER_TYP VALIDOE TYPE CUSTOMER_TYP VALIDOE TYPE CUST_ADDRESS_TYP VALIDOE TYPE INVENTORY_LIST_TYP VALIDOE TYPE INVENTORY_TYP VALIDOE TYPE LEAF_CATEGORY_TYP $VSN_1 VALIDOE TYPE LEAF_CATEGORY_TYP VALIDOE TYPE LINEITEMS_T VALIDOE TYPE LINEITEM_T VALIDOE TYPE LINEITEM_V VALIDOE TYPE ORDER_ITEM_LIST_TYP VALIDOE TYPE ORDER_ITEM_TYP VALIDOE TYPE ORDER_LIST_TYP VALIDOE TYPE ORDER_TYP VALIDOE TYPE PART_T VALIDOE TYPE PHONE_LIST_TYP VALIDOE TYPE PRODUCT_INFORMATION_TYP VALIDOE TYPE PRODUCT_REF_LIST_TYP VALIDOE TYPE PURCHASEORDER_T VALIDOE TYPE REJECTION_T VALIDOE TYPE SHIPPING_INSTRUCTIONS_T VALIDOE TYPE SUBCATEGORY_REF_LIST_TYP VALIDOE TYPE WAREHOUSE_TYP VALIDOE TYPE BODY CATALOG_TYP VALIDOE TYPE BODY COMPOSITE_CATEGORY_TYP VALIDOE TYPE BODY LEAF_CATEGORY_TYP VALIDOE VIEW ORDERS_VIEW VALIDOE VIEW PRODUCTS VALIDOE VIEW PRODUCT_PRICES VALIDPM INDEX PRINTMEDIA_PK VALIDPM TABLE PRINT_MEDIA VALIDPM TABLE TEXTDOCS_NESTEDTAB VALIDPM TYPE ADHEADER_TYP VALIDPM TYPE TEXTDOC_TAB VALIDPM TYPE TEXTDOC_TYP VALIDSH DIMENSION CHANNELS_DIM VALIDSH DIMENSION CUSTOMERS_DIM VALIDSH DIMENSION PRODUCTS_DIM VALIDSH DIMENSION PROMOTIONS_DIM VALIDSH DIMENSION TIMES_DIM VALIDSH INDEX CHANNELS_PK VALIDSH INDEX COSTS_PROD_BIX VALIDSH INDEX COSTS_TIME_BIX VALIDSH INDEX COUNTRIES_PK VALIDSH INDEX CUSTOMERS_GENDER_BIX VALIDSH INDEX CUSTOMERS_MARITAL_BIX VALIDSH INDEX CUSTOMERS_PK VALIDSH INDEX CUSTOMERS_YOB_BIX VALIDSH INDEX FW_PSC_S_MV_CHAN_BIX VALIDSH INDEX FW_PSC_S_MV_PROMO_BIX VALIDSH INDEX FW_PSC_S_MV_SUBCAT_BIX VALIDSH INDEX FW_PSC_S_MV_WD_BIX VALIDSH INDEX PRODUCTS_PK VALIDSH INDEX PRODUCTS_PROD_CAT_IX VALIDSH INDEX PRODUCTS_PROD_STATUS_BIX VALIDSH INDEX PRODUCTS_PROD_SUBCAT_IX VALIDSH INDEX PROMO_PK VALIDSH INDEX SALES_CHANNEL_BIX VALIDSH INDEX SALES_CUST_BIX VALIDSH INDEX SALES_PROD_BIX VALIDSH INDEX SALES_PROMO_BIX VALIDSH INDEX SALES_TIME_BIX VALIDSH INDEX TIMES_PK VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_1995 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_1996 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_H1_1997 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_H2_1997 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q1_1998 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q1_1999 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q1_2000 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q1_2001 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q1_2002 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q1_2003 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q2_1998 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q2_1999 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q2_2000 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q2_2001 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q2_2002 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q2_2003 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q3_1998 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q3_1999 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q3_2000 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q3_2001 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q3_2002 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q3_2003 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q4_1998 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q4_1999 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q4_2000 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q4_2001 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q4_2002 VALIDSH INDEX PARTITION COSTS_PROD_BIX COSTS_Q4_2003 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_1995 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_1996 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_H1_1997 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_H2_1997 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q1_1998 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q1_1999 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q1_2000 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q1_2001 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q1_2002 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q1_2003 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q2_1998 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q2_1999 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q2_2000 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q2_2001 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q2_2002 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q2_2003 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q3_1998 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q3_1999 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q3_2000 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q3_2001 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q3_2002 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q3_2003 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q4_1998 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q4_1999 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q4_2000 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q4_2001 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q4_2002 VALIDSH INDEX PARTITION COSTS_TIME_BIX COSTS_Q4_2003 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_1995 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_1996 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_H1_1997 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_H2_1997 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q1_1998 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q1_1999 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q1_2000 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q1_2001 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q1_2002 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q1_2003 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q2_1998 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q2_1999 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q2_2000 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q2_2001 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q2_2002 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q2_2003 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q3_1998 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q3_1999 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q3_2000 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q3_2001 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q3_2002 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q3_2003 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q4_1998 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q4_1999 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q4_2000 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q4_2001 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q4_2002 VALIDSH INDEX PARTITION SALES_CHANNEL_BIX SALES_Q4_2003 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_1995 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_1996 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_H1_1997 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_H2_1997 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q1_1998 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q1_1999 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q1_2000 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q1_2001 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q1_2002 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q1_2003 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q2_1998 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q2_1999 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q2_2000 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q2_2001 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q2_2002 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q2_2003 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q3_1998 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q3_1999 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q3_2000 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q3_2001 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q3_2002 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q3_2003 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q4_1998 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q4_1999 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q4_2000 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q4_2001 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q4_2002 VALIDSH INDEX PARTITION SALES_CUST_BIX SALES_Q4_2003 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_1995 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_1996 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_H1_1997 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_H2_1997 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q1_1998 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q1_1999 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q1_2000 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q1_2001 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q1_2002 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q1_2003 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q2_1998 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q2_1999 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q2_2000 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q2_2001 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q2_2002 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q2_2003 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q3_1998 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q3_1999 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q3_2000 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q3_2001 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q3_2002 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q3_2003 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q4_1998 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q4_1999 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q4_2000 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q4_2001 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q4_2002 VALIDSH INDEX PARTITION SALES_PROD_BIX SALES_Q4_2003 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_1995 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_1996 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_H1_1997 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_H2_1997 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q1_1998 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q1_1999 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q1_2000 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q1_2001 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q1_2002 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q1_2003 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q2_1998 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q2_1999 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q2_2000 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q2_2001 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q2_2002 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q2_2003 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q3_1998 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q3_1999 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q3_2000 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q3_2001 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q3_2002 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q3_2003 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q4_1998 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q4_1999 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q4_2000 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q4_2001 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q4_2002 VALIDSH INDEX PARTITION SALES_PROMO_BIX SALES_Q4_2003 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_1995 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_1996 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_H1_1997 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_H2_1997 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q1_1998 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q1_1999 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q1_2000 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q1_2001 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q1_2002 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q1_2003 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q2_1998 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q2_1999 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q2_2000 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q2_2001 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q2_2002 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q2_2003 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q3_1998 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q3_1999 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q3_2000 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q3_2001 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q3_2002 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q3_2003 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q4_1998 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q4_1999 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q4_2000 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q4_2001 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q4_2002 VALIDSH INDEX PARTITION SALES_TIME_BIX SALES_Q4_2003 VALIDSH MATERIALIZED VIEW CAL_MONTH_SALES_MV VALIDSH MATERIALIZED VIEW FWEEK_PSCAT_SALES_MV VALIDSH TABLE CAL_MONTH_SALES_MV VALIDSH TABLE CHANNELS VALIDSH TABLE COSTS VALIDSH TABLE COUNTRIES VALIDSH TABLE CUSTOMERS VALIDSH TABLE FWEEK_PSCAT_SALES_MV VALIDSH TABLE PRODUCTS VALIDSH TABLE PROMOTIONS VALIDSH TABLE SALES VALIDSH TABLE SALES_TRANSACTIONS_EXT VALIDSH TABLE SUPPLEMENTARY_DEMOGRAPHICS VALIDSH TABLE TIMES VALIDSH TABLE PARTITION COSTS COSTS_1995 VALIDSH TABLE PARTITION COSTS COSTS_1996 VALIDSH TABLE PARTITION COSTS COSTS_H1_1997 VALIDSH TABLE PARTITION COSTS COSTS_H2_1997 VALIDSH TABLE PARTITION COSTS COSTS_Q1_1998 VALIDSH TABLE PARTITION COSTS COSTS_Q1_1999 VALIDSH TABLE PARTITION COSTS COSTS_Q1_2000 VALIDSH TABLE PARTITION COSTS COSTS_Q1_2001 VALIDSH TABLE PARTITION COSTS COSTS_Q1_2002 VALIDSH TABLE PARTITION COSTS COSTS_Q1_2003 VALIDSH TABLE PARTITION COSTS COSTS_Q2_1998 VALIDSH TABLE PARTITION COSTS COSTS_Q2_1999 VALIDSH TABLE PARTITION COSTS COSTS_Q2_2000 VALIDSH TABLE PARTITION COSTS COSTS_Q2_2001 VALIDSH TABLE PARTITION COSTS COSTS_Q2_2002 VALIDSH TABLE PARTITION COSTS COSTS_Q2_2003 VALIDSH TABLE PARTITION COSTS COSTS_Q3_1998 VALIDSH TABLE PARTITION COSTS COSTS_Q3_1999 VALIDSH TABLE PARTITION COSTS COSTS_Q3_2000 VALIDSH TABLE PARTITION COSTS COSTS_Q3_2001 VALIDSH TABLE PARTITION COSTS COSTS_Q3_2002 VALIDSH TABLE PARTITION COSTS COSTS_Q3_2003 VALIDSH TABLE PARTITION COSTS COSTS_Q4_1998 VALIDSH TABLE PARTITION COSTS COSTS_Q4_1999 VALIDSH TABLE PARTITION COSTS COSTS_Q4_2000 VALIDSH TABLE PARTITION COSTS COSTS_Q4_2001 VALIDSH TABLE PARTITION COSTS COSTS_Q4_2002 VALIDSH TABLE PARTITION COSTS COSTS_Q4_2003 VALIDSH TABLE PARTITION SALES SALES_1995 VALIDSH TABLE PARTITION SALES SALES_1996 VALIDSH TABLE PARTITION SALES SALES_H1_1997 VALIDSH TABLE PARTITION SALES SALES_H2_1997 VALIDSH TABLE PARTITION SALES SALES_Q1_1998 VALIDSH TABLE PARTITION SALES SALES_Q1_1999 VALIDSH TABLE PARTITION SALES SALES_Q1_2000 VALIDSH TABLE PARTITION SALES SALES_Q1_2001 VALIDSH TABLE PARTITION SALES SALES_Q1_2002 VALIDSH TABLE PARTITION SALES SALES_Q1_2003 VALIDSH TABLE PARTITION SALES SALES_Q2_1998 VALIDSH TABLE PARTITION SALES SALES_Q2_1999 VALIDSH TABLE PARTITION SALES SALES_Q2_2000 VALIDSH TABLE PARTITION SALES SALES_Q2_2001 VALIDSH TABLE PARTITION SALES SALES_Q2_2002 VALIDSH TABLE PARTITION SALES SALES_Q2_2003 VALIDSH TABLE PARTITION SALES SALES_Q3_1998 VALIDSH TABLE PARTITION SALES SALES_Q3_1999 VALIDSH TABLE PARTITION SALES SALES_Q3_2000 VALIDSH TABLE PARTITION SALES SALES_Q3_2001 VALIDSH TABLE PARTITION SALES SALES_Q3_2002 VALIDSH TABLE PARTITION SALES SALES_Q3_2003 VALIDSH TABLE PARTITION SALES SALES_Q4_1998 VALIDSH TABLE PARTITION SALES SALES_Q4_1999 VALIDSH TABLE PARTITION SALES SALES_Q4_2000 VALIDSH TABLE PARTITION SALES SALES_Q4_2001 VALIDSH TABLE PARTITION SALES SALES_Q4_2002 VALIDSH TABLE PARTITION SALES SALES_Q4_2003 VALIDSH VIEW PROFITS VALID459 rows selected.Data types usedOWNER DATA_TYPE DATA_TYPE_OWNER DAT COUNT(*)------ ----------------------------------- ---------------- --- ----------PM ADHEADER_TYP PM 1IX ANYDATA SYS 7IX AQ$_SIG_PROP SYS 4PM BFILE 1PM BLOB 2HR CHAR 3IX CHAR 2SH CHAR 4IX CLOB 2PM CLOB 2HR DATE 3IX DATE 6OE DATE 1SH DATE 19OE INTERVAL YEAR(2) TO MONTH 2PM NCLOB 1HR NUMBER 21IX NUMBER 107OE NUMBER 40PM NUMBER 2SH NUMBER 94OE NVARCHAR2 4IX ORDER_EVENT_TYP IX 3IX RAW 32IX ROWID 6PM TEXTDOC_TAB PM 1IX TIMESTAMP(6) 25OE TIMESTAMP(6) WITH LOCAL TIME ZONE 1IX TIMESTAMP(6) WITH TIME ZONE 8IX TIMESTAMP(9) 2HR VARCHAR2 24IX VARCHAR2 128OE VARCHAR2 13SH VARCHAR2 46OE XMLTYPE SYS 135 rows selected.XML tablesOWNER TABLE_NAME SCHEMA_OWNER STORAGE_TYPE------ ------------------------------ ---------------- --------------------OE PURCHASEORDER OE OBJECT-RELATIONAL1 row selected.All objects named 'SYS%' (LOBs etc)OWNER OBJECT_TYPE STATUS COUNT(*)------ -------------------- -------- ----------IX INDEX VALID 16OE INDEX VALID 19PM INDEX VALID 9IX LOB VALID 3OE LOB VALID 8PM LOB VALID 7IX TABLE VALID 27 rows selected.All constraintsOWNER CONSTRAINT_TYPE STATUS VALIDATED GENERATED COUNT(*)------ -------------------- -------- ---------------- ---------------- ----------IX Check or Not Null ENABLED VALIDATED GENERATED NAME 4OE Check or Not Null ENABLED VALIDATED GENERATED NAME 2SH Check or Not Null ENABLED VALIDATED GENERATED NAME 115HR Check or Not Null ENABLED VALIDATED USER NAME 15OE Check or Not Null ENABLED VALIDATED USER NAME 9SH Foreign key DISABLED NOT VALIDATED USER NAME 2OE Foreign key ENABLED NOT VALIDATED USER NAME 1SH Foreign key ENABLED NOT VALIDATED USER NAME 8HR Foreign key ENABLED VALIDATED USER NAME 10OE Foreign key ENABLED VALIDATED USER NAME 4PM Foreign key ENABLED VALIDATED USER NAME 1SH Primary key DISABLED NOT VALIDATED USER NAME 1SH Primary key ENABLED NOT VALIDATED USER NAME 6IX Primary key ENABLED VALIDATED GENERATED NAME 13OE Primary key ENABLED VALIDATED GENERATED NAME 3HR Primary key ENABLED VALIDATED USER NAME 7OE Primary key ENABLED VALIDATED USER NAME 6PM Primary key ENABLED VALIDATED USER NAME 1HR Read only view ENABLED NOT VALIDATED GENERATED NAME 1IX Read only view ENABLED NOT VALIDATED GENERATED NAME 8OE Unique key ENABLED VALIDATED GENERATED NAME 6PM Unique key ENABLED VALIDATED GENERATED NAME 1HR Unique key ENABLED VALIDATED USER NAME 123 rows selected.All dimensionsOWNER DIMENSION_NAME I COMPILE_STATE------ -------------------- - -------------SH CHANNELS_DIM N VALIDSH CUSTOMERS_DIM N VALIDSH PRODUCTS_DIM N VALIDSH PROMOTIONS_DIM N VALIDSH TIMES_DIM N VALID5 rows selected.All granted rolesGRANTED_ROLE GRANTEE------------------------- -------AQ_ADMINISTRATOR_ROLE IXAQ_USER_ROLE IXCONNECT IXCONNECT PMRESOURCE BIRESOURCE HRRESOURCE IXRESOURCE OERESOURCE PMRESOURCE SHSELECT_CATALOG_ROLE IXSELECT_CATALOG_ROLE SHXDBADMIN OE13 rows selected.All granted system privilegesPRIVILEGE GRANTEE------------------------- -------ALTER SESSION BIALTER SESSION HRALTER SESSION IXALTER SESSION SHCREATE CLUSTER BICREATE CLUSTER IXCREATE CLUSTER SHCREATE DATABASE LINK BICREATE DATABASE LINK HRCREATE DATABASE LINK IXCREATE DATABASE LINK OECREATE DATABASE LINK SHCREATE DIMENSION SHCREATE INDEXTYPE IXCREATE MATERIALIZED VIEW OECREATE MATERIALIZED VIEW SHCREATE OPERATOR IXCREATE PROCEDURE IXCREATE RULE IXCREATE RULE SET IXCREATE SEQUENCE BICREATE SEQUENCE HRCREATE SEQUENCE IXCREATE SEQUENCE SHCREATE SESSION BICREATE SESSION HRCREATE SESSION IXCREATE SESSION OECREATE SESSION SHCREATE SYNONYM BICREATE SYNONYM HRCREATE SYNONYM IXCREATE SYNONYM OECREATE SYNONYM SHCREATE TABLE BICREATE TABLE IXCREATE TABLE SHCREATE TRIGGER IXCREATE TYPE IXCREATE VIEW BICREATE VIEW HRCREATE VIEW IXCREATE VIEW OECREATE VIEW SHQUERY REWRITE OEQUERY REWRITE SHSELECT ANY DICTIONARY IXUNLIMITED TABLESPACE BIUNLIMITED TABLESPACE HRUNLIMITED TABLESPACE IXUNLIMITED TABLESPACE OEUNLIMITED TABLESPACE PMUNLIMITED TABLESPACE SH53 rows selected.All granted object privilegesOWNER TABLE_NAME PRIVILEGE GRANTEE------ ------------------------------ ------------------------- -------HR COUNTRIES REFERENCES OEHR COUNTRIES SELECT OEHR DEPARTMENTS SELECT OEHR EMPLOYEES REFERENCES OEHR EMPLOYEES SELECT OEHR JOBS SELECT OEHR JOB_HISTORY SELECT OEHR LOCATIONS REFERENCES OEHR LOCATIONS SELECT OEOE INVENTORIES SELECT BIOE INVENTORIES SELECT PMOE ORDERS SELECT BIOE ORDERS SELECT PMOE ORDER_ITEMS SELECT BIOE ORDER_ITEMS SELECT PMOE PRODUCTS SELECT BIOE PRODUCT_DESCRIPTIONS SELECT BIOE PRODUCT_DESCRIPTIONS SELECT PMOE PRODUCT_INFORMATION REFERENCES PMOE PRODUCT_INFORMATION SELECT BIOE PRODUCT_INFORMATION SELECT PMOE PRODUCT_PRICES SELECT BIOE PROMOTIONS SELECT BISH CAL_MONTH_SALES_MV SELECT BISH CHANNELS SELECT BISH COSTS SELECT BISH COUNTRIES SELECT BISH CUSTOMERS SELECT BISH FWEEK_PSCAT_SALES_MV SELECT BISH PRODUCTS SELECT BISH PROMOTIONS SELECT BISH SALES SELECT BISH TIMES SELECT BISYS AQ$_UNFLUSHED_DEQUEUES SELECT IXSYS DATA_FILE_DIR READ SHSYS DBMS_APPLY_ADM EXECUTE IXSYS DBMS_AQ EXECUTE IXSYS DBMS_AQADM EXECUTE IXSYS DBMS_AQ_BQVIEW EXECUTE IXSYS DBMS_CAPTURE_ADM EXECUTE IXSYS DBMS_FLASHBACK EXECUTE IXSYS DBMS_PROPAGATION_ADM EXECUTE IXSYS DBMS_STATS EXECUTE HRSYS DBMS_STATS EXECUTE IXSYS DBMS_STATS EXECUTE OESYS DBMS_STATS EXECUTE PMSYS DBMS_STATS EXECUTE SHSYS DBMS_STREAMS_ADM EXECUTE IXSYS LOG_FILE_DIR READ SHSYS LOG_FILE_DIR WRITE SHSYS MEDIA_DIR READ PMSYS QT19972_BUFFER SELECT IXSYS QT19999_BUFFER SELECT IXSYS SS_OE_XMLDIR READ OESYS SS_OE_XMLDIR WRITE OESYS SUBDIR READ OESYS SUBDIR WRITE OE57 rows selected.Space usageOWNER SEGMENT_TYPE SUM(BYTES)------ -------------------- ----------HR INDEX 1245184HR TABLE 393216HR 1638400IX INDEX 917504IX TABLE 524288IX LOBINDEX 196608IX LOBSEGMENT 393216IX 2031616OE INDEX 2359296OE TABLE 2686976OE LOBINDEX 655360OE LOBSEGMENT 1310720OE NESTED TABLE 589824OE 7602176PM INDEX 196608PM TABLE 65536PM LOBINDEX 458752PM LOBSEGMENT 5373952PM NESTED TABLE 65536PM 6160384SH INDEX 2293760SH TABLE 19726336SH INDEX PARTITION 680132608SH TABLE PARTITION 134217728SH 836370432 85380300826 rows selected.Table cardinality relational and object tablesOWNER TABLE_NAME NUM_ROWS------ ------------------------------ ----------HR COUNTRIES 25HR DEPARTMENTS 27HR EMPLOYEES 107HR JOBS 19HR JOB_HISTORY 10HR LOCATIONS 23HR REGIONS 4IX AQ$_ORDERS_QUEUETABLE_G 0IX AQ$_ORDERS_QUEUETABLE_H 2IX AQ$_ORDERS_QUEUETABLE_I 2IX AQ$_ORDERS_QUEUETABLE_L 2IX AQ$_ORDERS_QUEUETABLE_S 4IX AQ$_ORDERS_QUEUETABLE_T 0IX AQ$_STREAMS_QUEUE_TABLE_C 0IX AQ$_STREAMS_QUEUE_TABLE_G 0IX AQ$_STREAMS_QUEUE_TABLE_H 0IX AQ$_STREAMS_QUEUE_TABLE_I 0IX AQ$_STREAMS_QUEUE_TABLE_L 0IX AQ$_STREAMS_QUEUE_TABLE_S 1IX AQ$_STREAMS_QUEUE_TABLE_T 0IX ORDERS_QUEUETABLEIX STREAMS_QUEUE_TABLEIX SYS_IOT_OVER_19986 0IX SYS_IOT_OVER_20015 0OE ACTION_TABLE 132OE CATEGORIES_TAB 4OE INVENTORIES 1112OE LINEITEM_TABLE 2232OE ORDERS 105OE ORDER_ITEMS 665OE PRODUCT_DESCRIPTIONS 8640OE PRODUCT_INFORMATION 288OE PRODUCT_REF_LIST_NESTEDTAB 0OE PROMOTIONS 2OE PURCHASEORDER 132OE SUBCATEGORY_REF_LIST_NESTEDTAB 3PM PRINT_MEDIA 4PM TEXTDOCS_NESTEDTAB 12SH CAL_MONTH_SALES_MV 48SH CHANNELS 5SH COSTS 0SH COUNTRIES 23SH CUSTOMERS 55500SH FWEEK_PSCAT_SALES_MV 11266SH PRODUCTS 72SH PROMOTIONS 503SH SALES 918843SH SALES_TRANSACTIONS_EXTSH SUPPLEMENTARY_DEMOGRAPHICS 4500SH TIMES 182650 rows selected.Index cardinality (without LOB indexes)OWNER INDEX_NAME DISTINCT_KEYS NUM_ROWS------ ------------------------- ------------- ----------HR COUNTRY_C_ID_PK 25 25HR DEPT_ID_PK 27 27HR DEPT_LOCATION_IX 7 27HR EMP_DEPARTMENT_IX 11 106HR EMP_EMAIL_UK 107 107HR EMP_EMP_ID_PK 107 107HR EMP_JOB_IX 19 107HR EMP_MANAGER_IX 18 106HR EMP_NAME_IX 107 107HR JHIST_DEPARTMENT_IX 6 10HR JHIST_EMPLOYEE_IX 7 10HR JHIST_EMP_ID_ST_DATE_PK 10 10HR JHIST_JOB_IX 8 10HR JOB_ID_PK 19 19HR LOC_CITY_IX 23 23HR LOC_COUNTRY_IX 14 23HR LOC_ID_PK 23 23HR LOC_STATE_PROVINCE_IX 17 17HR REG_ID_PK 4 4IX AQ$_STREAMS_QUEUE_TABLE_Y 0 0OE ACTION_TABLE_MEMBERS 132 132OE INVENTORY_IX 1112 1112OE INV_PRODUCT_IX 208 1112OE ITEM_ORDER_IX 105 665OE ITEM_PRODUCT_IX 185 665OE LINEITEM_TABLE_MEMBERS 132 132OE ORDER_ITEMS_PK 665 665OE ORDER_ITEMS_UK 665 665OE ORDER_PK 105 105OE ORD_CUSTOMER_IX 47 105OE ORD_ORDER_DATE_IX 105 105OE ORD_SALES_REP_IX 9 70OE PRD_DESC_PK 8640 8640OE PRODUCT_INFORMATION_PK 288 288OE PROD_NAME_IX 3727 8640OE PROD_SUPPLIER_IX 62 288OE PROMO_ID_PK 2 2PM PRINTMEDIA_PK 4 4SH CHANNELS_PK 5 5SH COSTS_PROD_BIX 0 0SH COSTS_TIME_BIX 0 0SH COUNTRIES_PK 23 23SH CUSTOMERS_GENDER_BIX 2 5SH CUSTOMERS_MARITAL_BIX 11 18SH CUSTOMERS_PK 55500 55500SH CUSTOMERS_YOB_BIX 75 75SH FW_PSC_S_MV_CHAN_BIX 4 4SH FW_PSC_S_MV_PROMO_BIX 4 4SH FW_PSC_S_MV_SUBCAT_BIX 21 21SH FW_PSC_S_MV_WD_BIX 210 210SH PRODUCTS_PK 72 72SH PRODUCTS_PROD_CAT_IX 5 72SH PRODUCTS_PROD_STATUS_BIX 1 1SH PRODUCTS_PROD_SUBCAT_IX 21 72SH PROMO_PK 503 503SH SALES_CHANNEL_BIX 4 92SH SALES_CUST_BIX 7059 35808SH SALES_PROD_BIX 72 1074SH SALES_PROMO_BIX 4 54SH SALES_TIME_BIX 1460 1460SH TIMES_PK 1826 182661 rows selected.SQL>
第七城市

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台