Skip to content

Instantly share code, notes, and snippets.

@tiennv90
Created October 26, 2015 09:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tiennv90/d6eee4178d3546d248f4 to your computer and use it in GitHub Desktop.
Save tiennv90/d6eee4178d3546d248f4 to your computer and use it in GitHub Desktop.
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Master table "FCIT_QA"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "FCIT_QA"."SYS_IMPORT_FULL_01": fcit_qa/********@xe directory=data_pump_dir DUMPFILE=dump_fcit_qa.dmp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"FCIT_QA"."BRANDENTITYHQ" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."BRANDENTITYHQ" ("BRAND_ID" NUMBER NOT NULL ENABLE, "BRAND_CODE" CHAR(1 BYTE), "BRAND_BID" NUMBER, "BRAND_NAME" VARCHAR2(255 BYTE), "BRAND_NAME_EN" VARCHAR2(255 BYTE), "PHONE" VARCHAR2(20 BYTE), "CONTACT_NAME" VARCHAR2(255 BYTE), "CONTACT_EMAIL" VARCHAR2(255 BYTE), "CONTACT_PHONE" VARCHAR2(20 BYTE), "CONTA
CT_MOBILE" VARCHAR2(20 BYTE), "RO
ORA-39083: Object type TABLE:"FCIT_QA"."CARUSAGE" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."CARUSAGE" ("USAGE_ID" NUMBER NOT NULL ENABLE, "COMPANY_ID" NUMBER NOT NULL ENABLE, "USAGE_FIELD" VARCHAR2(255 BYTE), "USAGE_FIELD_EN" VARCHAR2(255 BYTE), "CREATED_BY" VARCHAR2(255 BYTE), "CREATED_DATE" DATE, "MODIFIED_BY" VARCHAR2(255 BYTE), "MODIFIED_DATE" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255 NOCOMPRESS LOGGING STORAGE(INITIAL
ORA-39083: Object type TABLE:"FCIT_QA"."CONTRACT" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."CONTRACT" ("CONTRACT_ID" NUMBER NOT NULL ENABLE, "COMPANY_ID" NUMBER NOT NULL ENABLE, "CONTRACT_NUMBER" VARCHAR2(255 BYTE), "CONTRACT_NAME" VARCHAR2(255 BYTE), "CONTRACT_NAME_EN" VARCHAR2(255 BYTE), "CONTRACT_ENTITY_TYPE" VARCHAR2(255 BYTE), "CONTRACT_ENTITY_ID" NUMBER, "CREATED_BY" VARCHAR2(255 BYTE), "C
REATED_DATE" DATE, "MODIFIED_BY" VARCH
ORA-39083: Object type TABLE:"FCIT_QA"."CONTRACTPERIOD" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."CONTRACTPERIOD" ("PERIOD_ID" NUMBER NOT NULL ENABLE, "CONTRACT_ID" NUMBER NOT NULL ENABLE, "CONTRACT_NAME" VARCHAR2(255 BYTE), "CONTRACT_NAME_EN" VARCHAR2(255 BYTE), "START_DATE" DATE, "END_DATE" DATE, "SPECIAL_DEAL_TEXT" VARCHAR2(255 BYTE), "SPECIAL_DEAL_TEXT_EN" VARCHAR2(255 BYTE), "SPECIAL_DEAL_PDF" VA
RCHAR2(255 BYTE), "CREATED_BY" V
ORA-39083: Object type TABLE:"FCIT_QA"."DEALER" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."DEALER" ("DEALER_ID" NUMBER NOT NULL ENABLE, "BRAND_ID" NUMBER NOT NULL ENABLE, "REGION_ID" NUMBER NOT NULL ENABLE, "DEALER_CODE" NUMBER, "DEALER_NAME" VARCHAR2(255 BYTE), "PHONE" VARCHAR2(20 BYTE), "CONTACT_NAME" VARCHAR2(255 BYTE), "CONTACT_EMAIL" VARCHAR2(255 BYTE), "CONTACT_PHONE" VARCHAR2(20 BYTE), "
CONTACT_MOBILE" VARCHAR2(20 BYTE), "ROOM
ORA-39083: Object type TABLE:"FCIT_QA"."DISCOUNTDATA" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."DISCOUNTDATA" ("DISCOUNT_ID" NUMBER NOT NULL ENABLE, "PERIOD_ID" NUMBER NOT NULL ENABLE, "MODEL_ID" NUMBER NOT NULL ENABLE, "CAR_MODEL" VARCHAR2(255 BYTE), "EQUIPMENT_LINE" VARCHAR2(255 BYTE), "CAR_MODEL_EN" VARCHAR2(255 BYTE), "EQUIPMENT_LINE_EN" VARCHAR2(255 BYTE), "MSRP" VARCHAR2(255 BYTE), "DISCOUNT"
VARCHAR2(255 BYTE), "FINAL_PRICE"
ORA-39083: Object type TABLE:"FCIT_QA"."FLEETCUSTOMER" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."FLEETCUSTOMER" ("COMPANY_ID" NUMBER NOT NULL ENABLE, "COMPANY_NAME" VARCHAR2(255 BYTE), "HR_CONTACT_NAME" VARCHAR2(255 BYTE), "HR_CONTACT_EMAIL" VARCHAR2(255 BYTE), "COMPANY_NAME_EN" VARCHAR2(255 BYTE), "HR_CONTACT_FNAME_EN" VARCHAR2(255 BYTE), "HR_CONTACT_LNAME_EN" VARCHAR2(255 BYTE), "HR_CONTACT_PHONE"
VARCHAR2(20 BYTE), "HR_CONTACT_MO
ORA-39083: Object type TABLE:"FCIT_QA"."FLEETCUSTOMERSUBBRANCH" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."FLEETCUSTOMERSUBBRANCH" ("BRANCH_ID" NUMBER NOT NULL ENABLE, "COMPANY_ID" NUMBER NOT NULL ENABLE, "BRANCH_NAME" VARCHAR2(255 BYTE), "CITY" VARCHAR2(255 BYTE), "CONTACT_NAME" VARCHAR2(255 BYTE), "PHONE" VARCHAR2(20 BYTE), "CONTACT_EMAIL" VARCHAR2(255 BYTE), "BRANCH_NAME_EN" VARCHAR2(255 BYTE), "CITY_EN" VA
RCHAR2(255 BYTE), "CONTA
ORA-39083: Object type TABLE:"FCIT_QA"."MASTERPRIVILEGE" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."MASTERPRIVILEGE" ("MASTER_PRIVILEGE_ID" NUMBER NOT NULL ENABLE, "PRIVILEGE_NAME_CN" VARCHAR2(255 BYTE), "PRIVILEGE_NAME" VARCHAR2(255 BYTE), "USER_TYPE" VARCHAR2(50 BYTE), "ACTION_ON" VARCHAR2(50 BYTE), "ACTION" VARCHAR2(50 BYTE), "SCREEN_NAME" VARCHAR2(50 BYTE), "CREATED_BY" VARCHAR2(255 BYTE), "CREATED_
DATE" DATE, "MODIFIED_BY" VARCH
ORA-39083: Object type TABLE:"FCIT_QA"."MASTERPROVINCECITY" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."MASTERPROVINCECITY" ("ID" NUMBER NOT NULL ENABLE, "PROVINCE" VARCHAR2(50 BYTE), "CITY" VARCHAR2(50 BYTE), "PROVINCE_EN" VARCHAR2(50 BYTE), "CITY_EN" VARCHAR2(50 BYTE), "CREATED_BY" VARCHAR2(255 BYTE), "CREATED_DATE" DATE, "MODIFIED_BY" VARCHAR2(255 BYTE), "MODIFIED_DATE" DATE) PCTFREE 10 PCTUSED 40 INITRA
NS 1 MAXTRANS 255 NOCOMPRESS
ORA-39083: Object type TABLE:"FCIT_QA"."MODEL" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."MODEL" ("MODEL_ID" NUMBER NOT NULL ENABLE, "BRAND_ID" NUMBER NOT NULL ENABLE, "MODEL_NAME" VARCHAR2(255 BYTE), "MODEL_NAME_EN" VARCHAR2(255 BYTE), "MODEL_IMAGE" VARCHAR2(255 BYTE), "CREATED_BY" VARCHAR2(255 BYTE), "CREATED_DATE" DATE, "MODIFIED_BY" VARCHAR2(255 BYTE), "MODIFIED_DATE" DATE) PCTFREE 10 PCTU
SED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS
ORA-39083: Object type TABLE:"FCIT_QA"."PREFERREDDEALERS" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."PREFERREDDEALERS" ("PR_DEALER_ID" NUMBER NOT NULL ENABLE, "COMPANY_ID" NUMBER NOT NULL ENABLE, "DEALER_ID" NUMBER NOT NULL ENABLE, "CREATED_BY" VARCHAR2(255 BYTE), "CREATED_DATE" DATE, "MODIFIED_BY" VARCHAR2(255 BYTE), "MODIFIED_DATE" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 104
ORA-39083: Object type TABLE:"FCIT_QA"."REGIONALBRAND" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."REGIONALBRAND" ("REGION_ID" NUMBER NOT NULL ENABLE, "BRAND_ID" NUMBER NOT NULL ENABLE, "REGION_NAME" VARCHAR2(255 BYTE), "CONTACT_NAME" VARCHAR2(255 BYTE), "CONTACT_EMAIL" VARCHAR2(255 BYTE), "PHONE" VARCHAR2(20 BYTE), "CONTACT_PHONE" VARCHAR2(20 BYTE), "CONTACT_MOBILE" VARCHAR2(20 BYTE), "ROOM" VARCHAR2(
255 BYTE), "BUILDING" VARCHAR2(25
ORA-39083: Object type TABLE:"FCIT_QA"."USERS" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."USERS" ("USER_ID" NUMBER NOT NULL ENABLE, "ACCOUNT_ID" VARCHAR2(255 BYTE), "PASSWORD" VARCHAR2(255 BYTE), "NAME" VARCHAR2(255 BYTE), "ACCOUNT_EMAIL" VARCHAR2(255 BYTE), "USER_TYPE" VARCHAR2(255 BYTE), "NAME_EN" VARCHAR2(255 BYTE), "DEALER_DEALER_ID" NUMBER, "REGIONALBRAND_REGION_ID" NUMBER, "BRANDENTITYHQ
_BRAND_ID" NUMBER, "FLEETCUSTOMER_COMPANY
ORA-39083: Object type TABLE:"FCIT_QA"."USERSPRIVILEGE" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."USERSPRIVILEGE" ("PRIVILEGE_ID" NUMBER NOT NULL ENABLE, "USER_ID" NUMBER NOT NULL ENABLE, "PRIVILEGE_NAME_CN" VARCHAR2(255 BYTE), "PRIVILEGE_NAME" VARCHAR2(255 BYTE), "PRIVILEGED" CHAR(1 BYTE), "MASTER_PRIVILEGE_ID" NUMBER NOT NULL ENABLE, "ACTION_ON" VARCHAR2(50 BYTE), "ACTION" VARCHAR2(50 BYTE), "CREATE
D_BY" VARCHAR2(255 BYTE), "CREAT
ORA-39083: Object type TABLE:"FCIT_QA"."VOUCHER" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."VOUCHER" ("VOUCHER_ID" NUMBER NOT NULL ENABLE, "COMPANY_ID" NUMBER NOT NULL ENABLE, "BRANCH_ID" NUMBER, "EMPLOYEE_NAME" VARCHAR2(255 BYTE), "EMPLOYEE_ID" VARCHAR2(255 BYTE), "MOBILE_NO" VARCHAR2(20 BYTE), "EMAIL_ID" VARCHAR2(255 BYTE), "PERSONAL_ID" VARCHAR2(255 BYTE), "BIRTH_DATE" DATE, "POSITION" VARCHA
R2(255 BYTE), "DEPARTMENT" VARCHAR2(255
ORA-39083: Object type TABLE:"FCIT_QA"."NOTIFYPERIODS" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."NOTIFYPERIODS" ("NOTIFY_ID" NUMBER NOT NULL ENABLE, "NOTIFY_PERIOD" NUMBER NOT NULL ENABLE, "NOTIFY_PERIOD_TXT" VARCHAR2(255 BYTE) NOT NULL ENABLE, "NOTIFY_FLAG" CHAR(1 BYTE), "CREATED_BY" VARCHAR2(255 BYTE), "CREATED_DATE" DATE, "MODIFIED_BY" VARCHAR2(255 BYTE), "MODIFIED_DATE" DATE) PCTFREE 10 PCTUSED 4
0 INITRANS 1 MAXTRANS 255 NOCOMPR
ORA-39083: Object type TABLE:"FCIT_QA"."VOUCHERTEMPLATEVERSION" failed to create with error:
ORA-00959: tablespace 'FCITTBS' does not exist
Failing sql is:
CREATE TABLE "FCIT_QA"."VOUCHERTEMPLATEVERSION" ("TEMPLATE_ID" NUMBER NOT NULL ENABLE, "BRAND_ID" NUMBER NOT NULL ENABLE, "TEMPLATE_NAME" VARCHAR2(255 BYTE), "HEADER_CONTENT" CLOB, "LOCAL_RESTRICTIONS" CLOB, "DELIVERY_OPTION" CLOB, "TERMS_CONDITIONS" CLOB, "HEADER_EN" CLOB, "LOCAL_RESTRICTIONS_EN" CLOB, "DELIVERY_OPTION_EN" CLOB
, "TERMS_CONDITIONS_EN"
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment