|
在RAS3上装了ORACLE9I,将从2000SERVER的ORACLE中的数据以工具的形式导出DMP文件,在LINUX下用imp命令也导入成功了,配置好APACHE和PHP,用<? PHPINFO(); ?>能看到ORACLE和ORCI8参数,提示都是ENABLE,但是打开网页的时候却显示CONNET ORACLE等一些连接数据库和函数 的出错提示
Warning: Unable to connect to ORACLE (Error while trying to retrieve text for error ORA-01019) in /mnt/e/parameter/CLASSIFYseach.php on line 65
Warning: ora_open(): supplied argument is not a valid Oracle-Connection resource in /mnt/e/parameter/CLASSIFYseach.php on line 66
Warning: ora_commiton(): supplied argument is not a valid Oracle-Connection resource in /mnt/e/parameter/CLASSIFYseach.php on line 67
Warning: ora_parse(): supplied argument is not a valid Oracle-Cursor resource in /mnt/e/parameter/CLASSIFYseach.php on line 69)
(网页应该没问题,在2000下试过,很正常,能正常显示,)ORACLE也用STARTUP启动了,LSNRCTL 也START了,用OEMAPP DBASTUDIO 打开后也能看到导入数据库的用户和一些资料,在LINUX下PHP连接ORACLE是不是还要装什么软件,
php编译如下:
./configure' '--prefix=/usr/local/php
--with-apache=../apache_1.3.20
--with-config-file-path=/usr/local/php
--with-gd=/usr
--with-jpeg-dir=/usr
--with-freetype-dir=/usr
--with-tiff-dir=/usr
--with-zlib-dir=/usr
--with-oracle=/opt/oracle/product/9.2
--with-oci8=/opt/oracle/product/9.2
--with-dbase
--enable-track-vars
--enable-magic-quotes
--enable-exif
--enable-inline-optimization -q
oracle参数:
export DISPLAY=\x{201D}127.0.0.1:0.0\x{201D}
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9.2
export PATH=$ORACLE_HOME/binORACLE_HOME/Apache/Apache/binPATH
export ORACLE_OWNER=oracle
export ORACLE_SID=oracledb
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=/opt/oracle/product/9.2/libLD_LIBRARY_PATH
export PATH=/opt/oracle/product/9.2/binPATH
export NLS_LANG=AMERICAN
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
oracle导入时的log:是不是ORACLE数据没有导入成功
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. importing QS_CS's objects into QS_CS
. . importing table "ADMIN" 12 rows imported
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_H" ("MSGID" RAW(16), "SUBSCRIBER#" "
"NUMBER, "NAME" VARCHAR2(30), "ADDRESS#" NUMBER, "DEQUEUE_TIME" DATE, "TRANS"
"ACTION_ID" VARCHAR2(30), "DEQUEUE_USER" NUMBER, "ROPAGATED_MSGID" RAW(16),"
" "RETRY_COUNT" NUMBER, "HINT" ROWID, "SPARE" RAW(16), PRIMARY KEY ("MSGID""
", "SUBSCRIBER#", "NAME", "ADDRESS#" ENABLE) USAGE QUEUE ORGANIZATION INDEX"
" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREE"
"LIST GROUPS 1) LOGGING NOCOMPRESS PCTTHRESHOLD 50"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_I" ("SUBSCRIBER#" NUMBER, "NAME" VA"
"RCHAR2(30), "QUEUE#" NUMBER, "MSG_ENQ_TIME" DATE, "MSG_STEP_NO" NUMBER, "MS"
"G_CHAIN_NO" NUMBER, "MSG_LOCAL_ORDER_NO" NUMBER, "MSGID" RAW(16), "HINT" RO"
"WID, "SPARE" RAW(16), PRIMARY KEY ("SUBSCRIBER#", "NAME", "QUEUE#", "MSG_E"
"NQ_TIME", "MSG_STEP_NO", "MSG_CHAIN_NO", "MSG_LOCAL_ORDER_NO", "MSGID" ENA"
"BLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) LOGG"
"ING NOCOMPRESS PCTTHRESHOLD 50"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_NR" ("MSGID" RAW(16), "SUBSCRIBER#""
" NUMBER, "NAME" VARCHAR2(30), "ADDRESS#" NUMBER, "SIGN" "SYS"."AQ$_SIG_PROP"
"", "DBS_SIGN" "SYS"."AQ$_SIG_PROP", PRIMARY KEY ("MSGID", "SUBSCRIBER#", ""
"NAME", "ADDRESS#" ENABLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITR"
"ANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TAB"
"LESPACE "EXAMPLE" LOGGING NOCOMPRESS PCTTHRESHOLD 50 INCLUDING "SIGN" OVERF"
"LOW PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL "
"65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "EXAMPLE""
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_S" ("SUBSCRIBER_ID" NUMBER NOT NULL"
" ENABLE, "QUEUE_NAME" VARCHAR2(30) NOT NULL ENABLE, "NAME" VARCHAR2(30), "A"
"DDRESS" VARCHAR2(1024), "ROTOCOL" NUMBER, "SUBSCRIBER_TYPE" NUMBER, "RULE_"
"NAME" VARCHAR2(30), "TRANS_NAME" VARCHAR2(61), "RULESET_NAME" VARCHAR2(61))"
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREEL"
"ISTS 1 FREELIST GROUPS 1) LOGGING NOCOMPRESS"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "AQ$_QS_CS_ORDER_STATUS_QT_T" ("NEXT_DATE" DATE, "TXN_ID" VARC"
"HAR2(30), "MSGID" RAW(16), "ACTION" NUMBER, PRIMARY KEY ("NEXT_DATE", "TXN"
"_ID", "MSGID" ENABLE) USAGE QUEUE ORGANIZATION INDEX PCTFREE 10 INITRANS "
"2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS PCTTHRESHOLD 50"
. . importing table "ATTRIBUTE" 16682 rows imported
. . importing table "CLASSIFY_FIRST" 20 rows imported
. . importing table "CLASSIFY_FORTH" 473 rows imported
. . importing table "CLASSIFY_SECOND" 114 rows imported
. . importing table "CLASSIFY_THIRD" 332 rows imported
. . importing table "COUNTRIES" 25 rows imported
. . importing table "COUNTS" 164 rows imported
. . importing table "DEPARTMENTS" 27 rows imported
. . importing table "EMPLOYEES" 107 rows imported
. . importing table "EPC_CLI_COLLECTION" 0 rows imported
. . importing table "EPC_CLI_COLLECT_BY_EVENTID" 0 rows imported
. . importing table "EPC_CLI_COLLECT_BY_USERID" 0 rows imported
. . importing table "EPC_CLI_ENVIRONMENT" 0 rows imported
. . importing table "EPC_CLI_ENVIRONMENT_VERSION" 0 rows imported
. . importing table "EPC_CLI_FDF_FILE" 0 rows imported
. . importing table "EPC_CLI_FORMAT" 0 rows imported
. . importing table "EPC_CLI_JOB" 0 rows imported
. . importing table "EPC_CLI_NODE" 0 rows imported
. . importing table "EPC_CLI_PROGRESS" 0 rows imported
. . importing table "EPC_CLI_REP_USERS" 0 rows imported
. . importing table "EPC_CLI_SERVICE" 0 rows imported
. . importing table "EPC_CLI_USAGE" 0 rows imported
. . importing table "EPC_CLI_VERSION" 1 rows imported
. . importing table "EPC_MULTI_VIEWS" 0 rows imported
. . importing table "EPC_MULTI_VIEW_MAP" 0 rows imported
. . importing table "EPC_MVIEW_CATEGORY_MAP" 0 rows imported
. . importing table "EPC_PRIMARY_ITEMS" 0 rows imported
. . importing table "EPC_TDV_VERSION" 1 rows imported
. . importing table "EPC_VIEW" 0 rows imported
. . importing table "EPC_VIEW_CATEGORY" 0 rows imported
. . importing table "EPC_VIEW_ITEMS" 0 rows imported
. . importing table "EPC_VIEW_PREFERENCES" 0 rows imported
. . importing table "JOBS" 19 rows imported
. . importing table "JOB_HISTORY" 10 rows imported
. . importing table "LOCATIONS" 23 rows imported
IMP-00060: Warning: Skipping table "QS_CS"."ORDER_STATUS_TABLE" because object
type "QS_ADM"."ORDERITEMLIST_VARTYP" does not exist or has different identifier
. . importing table "ARAMETERINTL_COM" 9 rows imported
. . importing table "RODUCTS" 114202 rows imported
IMP-00060: Warning: Skipping table "QS_CS"."QS_CS_ORDER_STATUS_QT" because object type "QS_ADM".
ORDERITEMLIST_VARTYP" does not exist or has different identifier
. . importing table "REGIONS" 4 rows imported
. . importing table "SMP_DBREPORT_SQLSCRIPTS" 0 rows imported
. . importing table "SMP_DBREPORT_TEMPLATE" 0 rows imported
. . importing table "SMP_LMV_DISPLAY_OPTION" 0 rows imported
. importing table "SMP_LMV_REDO_LOG" 0 rows imported
. . importing table "SMP_LMV_SEARCH_RESULT" 0 rows imported
. . importing table "SMP_LOG_SQL" 0 rows imported
. . importing table "SMP_STANDBY_CONFIG_INFO" 0 rows imported
. . importing table "SMP_STANDBY_SITE_INFO" 0 rows imported
. . importing table "SMP_VAI_DBCONFIG" 0 rows imported
. . importing table "SMP_VAR_EBU_ACTIVE_JOB_" 0 rows imported
. . importing table "SMP_VAR_EBU_SAVED_JOB_" 0 rows imported
. . importing table "SMP_VAR_OS_ACTIVE_JOB_" 0 rows imported
. . importing table "SMP_VAR_OS_SAVED_JOB_" 0 rows imported
. . importing table "SMP_VAR_SMR_ACTIVE_JOB_" 0 rows imported
. . importing table "SMP_VAR_SMR_CHANNEL_DEVICE_" 0 rows imported
. . importing table "SMP_VAR_SMR_DEFAULT_CHANNEL_" 0 rows imported
. . importing table "SMP_VAR_SMR_LIST_DATABASES_" 0 rows imported
. . importing table "SMP_VAR_SMR_RC_CONNECT_STRING_" 0 rows imported
. . importing table "SMP_VAR_SMR_SAVED_JOB_" 0 rows imported
. . importing table "SMP_VAR_SMR_TEMP_SCRIPTS_" 0 rows imported
. . importing table "SMP_VBOR_BACKUP_CONFIGURATION" 0 rows imported
. . importing table "SMP_VBOR_BLOB" 0 rows imported
. . importing table "SMP_VBOR_CHANNELS_INFORMATION" 0 rows imported
. . importing table "SMP_VBOR_DEFAULT_CONFIG" 0 rows imported
. . importing table "SMP_VBOR_STRATEGY_INFORMATION" 0 rows imported
. . importing table "SMP_VBO_JOB_CONFIG_TABLE" 0 rows imported
. . importing table "SMP_VBO_REPORTS" 52 rows imported
. . importing table "SMP_VBO_REPORTS_CONFIG" 0 rows imported
. . importing table "SMP_VBO_REPORTS_TYPE_DEFN" 27 rows imported
. . importing table "SMP_VBO_REPORT_ELEMENTS" 245 rows imported
. . importing table "SMP_VBO_REPORT_INFO_SOURCES" 0 rows imported
. . importing table "SMP_VDD_OPERATIONS_TABLE" 1 rows imported
. . importing table "SMP_VDE_EVENT" 0 rows imported
. . importing table "SMP_VDE_EVENT_ARCHIVE" 0 rows imported
. . importing table "SMP_VDE_EVENT_ARCHIVE_PURGE" 1 rows imported
. . importing table "SMP_VDE_EVENT_DETAILS" 0 rows imported
. . importing table "SMP_VDE_EVENT_LOCK_TAB" 0 rows imported
. . importing table "SMP_VDE_EVENT_LOG" 0 rows imported
. . importing table "SMP_VDE_EVENT_OCCURRENCE" 0 rows imported
. . importing table "SMP_VDE_EVENT_OCCUR_DETAILS" 0 rows imported
. . importing table "SMP_VDE_EVENT_TARGET_ACK" 0 rows imported
. . importing table "SMP_VDE_EVENT_TARGET_DETAILS" 0 rows imported
. . importing table "SMP_VDE_EVENT_TARGET_INFO" 0 rows imported
. . importing table "SMP_VDE_EVENT_TARGET_STATE" 0 rows imported
. . importing table "SMP_VDE_EVENT_UPDOWN_QUEUE" 0 rows imported
. . importing table "SMP_VDE_METRIC_THRESHOLDS" 14 rows imported
. . importing table "SMP_VDE_NODE_UPDOWN_QUEUE" 0 rows imported
. . importing table "SMP_VDE_THRESHOLD_ASSOC" 0 rows imported
. . importing table "SMP_VDE_TRY_REMOVE_EVENT_QUEUE" 0 rows imported
. . importing table "SMP_VDF_MASLIST" 1 rows imported
. importing table "SMP_VDG_EVENTID_MAP" 0 rows imported
. importing table "SMP_VDG_EVENT_DELETE_LIST" 0 rows imported
. importing table "SMP_VDG_EVENT_NOTIF_LIST" 0 rows imported
. . importing table "SMP_VDG_GATEWAY_MAP" 0 rows imported
. . importing table "SMP_VDG_JOBID_MAP" 0 rows imported
. importing table "SMP_VDG_NODE_LIST" 1 rows imported
. . importing table "SMP_VDG_NODE_LOCK_TABLE" 1 rows imported
. . importing table "SMP_VDI_AOBJECT_NOTIFICATION" 0 rows imported
. importing table "SMP_VDI_OBJECT_TABLE" 0 rows imported
. . importing table "SMP_VDI_POS" 0 rows imported
. importing table "SMP_VDI_TARGET_PROPERTIES" 0 rows imported
. . importing table "SMP_VDJ_JOB" 0 rows imported
. . importing table "SMP_VDJ_JOB_LOCK" 0 rows imported
. . importing table "SMP_VDJ_JOB_LOG" 0 rows imported
. . importing table "SMP_VDJ_JOB_LOG_COMMENT" 0 rows imported
. . importing table "SMP_VDJ_JOB_LOG_INTERMED" 0 rows imported
. . importing table "SMP_VDJ_JOB_OUTPUT" 1 rows imported
. . importing table "SMP_VDJ_JOB_PER_TARGET" 0 rows imported
. . importing table "SMP_VDJ_JOB_TARGET" 0 rows imported
. . importing table "SMP_VDM_ADDRESS" 0 rows imported
. . importing table "SMP_VDM_GLOBAL_INFO" 0 rows imported
. . importing table "SMP_VDM_LAST_NOTIF_SEQ_PERTYPE" 6 rows imported
. . importing table "SMP_VDM_NOTIFICATION" 0 rows imported
. . importing table "SMP_VDM_NOTIFICATION_DETAILS" 0 rows imported
. importing table "SMP_VDM_NOTIFICATION_NVPAIRS" 0 rows imported
. . importing table "SMP_VDM_NOTIFICATION_SERVICES" 0 rows imported
. importing table "SMP_VDM_PAGING_CARRIER_INFO" 0 rows imported
. importing table "SMP_VDM_SESSION_NOTIFTYPE_PAIR" 0 rows imported
. . importing table "SMP_VDN_BLACKOUTSCHEDULE" 0 rows imported
. . importing table "SMP_VDN_GROUP_GROUP" 0 rows imported
. importing table "SMP_VDN_GROUP_LIST" 0 rows imported
. . importing table "SMP_VDN_GROUP_TARGET" 0 rows imported
. . importing table "SMP_VDN_NODE_LIST" 1 rows imported
. . importing table "SMP_VDN_NOTIFY" 0 rows imported
. importing table "SMP_VDN_STATE" 6 rows imported
. . importing table "SMP_VDN_TARGET_LIST" 6 rows imported
. . importing table "SMP_VDN_TARGET_PROPERTIES" 11 rows imported
. . importing table "SMP_VDN_TARGET_TYPE_DEFN" 6 rows imported
. . importing table "SMP_VDO_JOBID_SERVICEID" 0 rows imported
. . importing table "SMP_VDP_NODES" 1 rows imported
. importing table "SMP_VDP_NODE_INFO" 1 rows imported
. importing table "SMP_VDP_NODE_INFO_VDD" 1 rows imported
. importing table "SMP_VDP_NODE_OMS_MAP" 1 rows imported
. . importing table "SMP_VDP_OMS_NUM_NODES" 1 rows imported
. . importing table "SMP_VDP_OMS_REGION_MAP" 1 rows imported
. . importing table "SMP_VDP_PGSRV_REGION_MAP" 0 rows imported
. importing table "SMP_VDP_REGIONS" 1 rows imported
. importing table "SMP_VDR_REGISTRY" 235 rows imported
. importing table "SMP_VDS_REPOS_VERSION" 8 rows imported
. . importing table "SMP_VDS_SESSIONS_TABLE" 0 rows imported
. importing table "SMP_VDU_CALLBACK_TABLE" 0 rows imported
. . importing table "SMP_VDU_OBJECTS_TABLE" 9 rows imported
. importing table "SMP_VDU_PRINCIPALS_TABLE" 2 rows imported
. importing table "SMP_VDU_PRIVILEGE_TABLE" 6 rows imported
. . importing table "SMP_VDV_DEFAULT_NOTIFY_PREFS" 0 rows imported
. importing table "SMP_VDV_DEFAULT_PERMISSIONS" 0 rows imported
. importing table "SMP_VDV_GENERAL" 0 rows imported
. . importing table "SMP_VDV_MAPI_EMAIL" 0 rows imported
. . importing table "SMP_VDV_NOTIFICATION_SCHEDULE" 0 rows imported
. importing table "SMP_VDV_PAGE" 2 rows imported
. . importing table "SMP_VDV_PAGING" 0 rows imported
. . importing table "SMP_VDV_PREFERRED_CREDENTIALS" 0 rows imported
. importing table "SMP_VDV_SERVICE_PARMS" 0 rows imported
. . importing table "SMP_VDV_SMTP_EMAIL" 2 rows imported
. importing table "SMP_VDV_USER" 2 rows imported
. . importing table "SMP_VDV_USER_LOCALE" 0 rows imported
. . importing table "SMP_VDV_USER_PREF" 0 rows imported
. importing table "SMP_VTA_DB_APP_POSITION_" 0 rows imported
. . importing table "SMP_VTC_LAYOUT_PROPERTIES" 0 rows imported
. . importing table "SMP_VTD_CLIENT_STATE" 0 rows imported
. importing table "SMP_VTD_DG_LOCATION" 0 rows imported
. importing table "SMP_VTD_HISTORICAL_LOCATION" 0 rows imported
. . importing table "SMP_VTM_CHART_DEFN" 0 rows imported
. . importing table "SMP_VTM_CHART_STATE_TARG_SPEC" 0 rows imported
. importing table "SMP_VTM_DISPLAY_STATE" 0 rows imported
. importing table "SMP_VTM_RECORDING_DATA" 0 rows imported
. importing table "SMP_VTM_UDCHART_COLUMNS" 0 rows imported
. importing table "SMP_VTM_UDCHART_DEFN" 0 rows imported
. importing table "SMP_VTP_UDCLASS_COLUMNS" 0 rows imported
. importing table "SMP_VTP_UDCLASS_DEFN" 0 rows imported
. importing table "SMP_VXA_SYSTEM_PREFS" 0 rows imported
. . importing table "VBZ$COMPARISONS" 0 rows imported
. importing table "VBZ$COMPARISON_RESULTS" 0 rows imported
. importing table "VBZ$DB_OBJ_NAMES" 0 rows imported
. importing table "VBZ$DESTINATIONS" 0 rows imported
. importing table "VBZ$DIRECTIVES" 0 rows imported
. . importing table "VBZ$EDITED_SCRIPTS" 0 rows imported
. importing table "VBZ$EXEMPLARS" 0 rows imported
. . importing table "VBZ$EX_UPDATES" 0 rows imported
. . importing table "VBZ$HISTORY" 0 rows imported
. importing table "VBZ$IMPACT_LOG" 0 rows imported
. . importing table "VBZ$OBJECT_GRANTS" 0 rows imported
. importing table "VBZ$OUTPUT_LOG" 0 rows imported
. importing table "VBZ$ROLE_GRANTS" 0 rows imported
. importing table "VBZ$SCHEMAMAPS" 0 rows imported
. importing table "VBZ$SCRIPTS" 0 rows imported
. . importing table "VBZ$SYS_PRIV_GRANTS" 0 rows imported
. importing table "VBZ$VERSION" 0 rows imported
. importing table "VDK_APPLICATION" 0 rows imported
. importing table "VDK_CLUSTER" 0 rows imported
. importing table "VDK_CLUSTER_COLUMN" 0 rows imported
. importing table "VDK_COLLECTION_ITEMS" 0 rows imported
. importing table "VDK_COLUMN" 0 rows imported
. importing table "VDK_CONSTRAINT" 0 rows imported
. importing table "VDK_CONSTRAINT_COLUMN" 0 rows imported
. importing table "VDK_DATABASE" 0 rows imported
. importing table "VDK_DATAFILE" 0 rows imported
. importing table "VDK_DATAFILE_STATS" 0 rows imported
. importing table "VDK_DATAFILE_STATS_BEGIN" 0 rows imported
. importing table "VDK_DBUSER" 0 rows imported
. importing table "VDK_DELETE_QUEUE" 0 rows imported
. importing table "VDK_FUNCTION" 0 rows imported
. importing table "VDK_HOST_INFO" 0 rows imported
. importing table "VDK_INDEX" 0 rows imported
importing table "VDK_INDEX_COLUMN" 0 rows imported
. importing table "VDK_IND_PARTITIONS" 0 rows imported
. importing table "VDK_IND_SUBPARTITIONS" 0 rows imported
. importing table "VDK_INSTANCE" 0 rows imported
. importing table "VDK_INSTANCE_BUFFER_STATS" 0 rows imported
. importing table "VDK_INSTANCE_BUFFER_STATS_B" 0 rows imported
. importing table "VDK_INSTANCE_PARAMS" 0 rows imported
. . importing table "VDK_INSTANCE_ROLLBACK_STATS" 0 rows imported
. importing table "VDK_INSTANCE_SORT_STATS" 0 rows imported
. importing table "VDK_INSTANCE_STATS" 0 rows imported
. importing table "VDK_INSTANCE_STATS_BEGIN" 0 rows imported
. importing table "VDK_LOG_TABLE" 0 rows imported
. importing table "VDK_OBJECT" 0 rows imported
. importing table "VDK_PART_INDEXES" 0 rows imported
. importing table "VDK_PART_KEY_COLUMNS" 0 rows imported
. importing table "VDK_PART_TABLES" 0 rows imported
. importing table "VDK_REP_CONTROL" 1 rows imported
. importing table "VDK_REQUEST" 0 rows imported
. importing table "VDK_SEGMENT" 0 rows imported
. importing table "VDK_SEQUENCE" 0 rows imported
. importing table "VDK_SERVICE" 0 rows imported
. importing table "VDK_SESSION" 0 rows imported
. importing table "VDK_SQL" 0 rows imported
. importing table "VDK_SQL_OBJECTS" 0 rows imported
. importing table "VDK_SQL_STATEMENT_WORK" 0 rows imported
. importing table "VDK_STORAGE_DEVICE" 0 rows imported
. importing table "VDK_SUBPART_KEY_COLUMNS" 0 rows imported
. importing table "VDK_SYNONYM" 0 rows imported
. . importing table "VDK_TABLE" 0 rows imported
. importing table "VDK_TABLESPACE" 0 rows imported
. importing table "VDK_TAB_PARTITIONS" 0 rows imported
. importing table "VDK_TAB_SUBPARTITIONS" 0 rows imported
. importing table "VDK_USER_RULE" 0 rows imported
. importing table "VMQ_DATABASE_PARAMS_DYNAMIC" 0 rows imported
. importing table "VMQ_DATABASE_PARAMS_STATIC" 0 rows imported
. importing table "VMQ_SQL_FAKE_INDEX" 0 rows imported
. . importing table "VMQ_SQL_FAKE_INDEX_COLUMNS" 0 rows imported
. . importing table "VMQ_SQL_IMPORT_STATS" 0 rows imported
. . importing table "VMQ_SQL_ITEM" 0 rows imported
. . importing table "VMQ_SQL_PLAN_COST_ALL" 0 rows imported
. . importing table "VMQ_SQL_PLAN_COST_FIRST" 0 rows imported
. importing table "VMQ_SQL_PLAN_RULE" 0 rows imported
. importing table "VMQ_SQL_STATS_COST_ALL" 0 rows imported
. . importing table "VMQ_SQL_STATS_COST_FIRST" 0 rows imported
. importing table "VMQ_SQL_STATS_RULE" 0 rows imported
. importing table "VMQ_SQL_TEXT" 0 rows imported
. importing table "VMQ_SQL_UNQUALIFIED_NAMES" 0 rows imported
. . importing table "ZH_CLASSIFY_COUNT" 44583 rows imported
. . importing table "ZH_COLLECTION" 8 rows imported
. importing table "ZH_GONGQIU" 258 rows imported
. . importing table "ZH_GRADE" 1 rows imported
. . importing table "ZH_KEYWORD" 787 rows imported
. importing table "ZH_NEWS" 396 rows imported
. importing table "ZH_SUPPLY" 220 rows imported
. importing table "ZH_SUPPLY_ANSWER" 16 rows imported
. importing table "ZH_UPLOAD" 1 rows imported
. . importing table "ZH_USER" 8877 rows imported
IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "QS_CS".secure_employees"
" BEFORE INSERT OR UPDATE OR DELETE ON employees"
"BEGIN" " secure_dml;"
"END secure_employees;"
IMP-00041: Warning: object created with compilation warnings
"CREATE TRIGGER "QS_CS".update_job_history"
" AFTER UPDATE OF job_id, department_id ON employees"
" FOR EACH ROW"
"BEGIN"
" add_job_history(ld.employee_id, ld.hire_date, sysdate,"
" ld.job_id, ld.department_id);"
"END;"
IMP-00017: following statement failed with ORACLE error 600:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE_TABLE('QS_CS_ORDER_STATUS_QT',1,125,2"
",0,0,'Customer Status multi consumer queue table');"
"COMMIT; END;"
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kwqickcidx:], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_AQ_SYS_IMP_INTERNAL", line 197
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 31
ORA-06512: at line 2
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('4E96F55AAF624CCBB722FF4871D"
"412DF'),'QS_CS_ORDER_STATUS_QT','AQ$_QS_CS_ORDER_STATUS_QT_E',1,0,0,0,0,'ex"
"ception queue');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE AQ$_QS_CS_ORDER_STATUS_QT_E. Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('168993796DB04A4083234310FAB"
"4C7E9'),'QS_CS_ORDER_STATUS_QT','QS_CS_BOOKEDORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE QS_CS_BOOKEDORDERS_QUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('AD05A30810E9420F915A81A325F"
"0DF33'),'QS_CS_ORDER_STATUS_QT','QS_CS_SHIPPEDORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE QS_CS_SHIPPEDORDERS_QUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('3F2D878F5BE948D98F9F2136CE3"
"9BB1E'),'QS_CS_ORDER_STATUS_QT','QS_CS_BILLEDORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object: CREATE QS_CS_BILLEDORDERS_QUE.
Remaining PL/SQL blocks for this object will be skipped.
IMP-00015: following statement failed because the object already exists:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('8D66D71E9BAC4D509A994694820"
"19849'),'QS_CS_ORDER_STATUS_QT','QS_CS_BACKORDERS_QUE',0,5,0,0,0,'');"
"COMMIT; END;"
IMP-00091: Above error occurred on the following function and object:
CREATE QS_CS_BACKORDERS_QUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00017: following statement failed with ORACLE error 3113:
"BEGIN "
"DECLARE "
"ta sys.re$table_alias_list;"
"vt sys.re$variable_type_list;
"BEGIN"
"ta := sys.re$table_alias_list();"
"vt := sys.re$variable_type_list();"
"ta.extend(1);"
"ta(1) := sys.re$table_alias('TAB','QS_CS_ORDER_STATUS_QT');"
"dbms_rule_imp_obj.import_evaluation_context('AQ$_QS_CS_ORDER_STATUS_QT_V', "
"ta, vt, NULL,NULL, 1);"
"END; "
"COMMIT; END;"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully |
|