IMP-00017: 由于 ORACLE 的 942 错误,以下的语句失败
"CREATE DIMENSION "CUSTOMERS_DIM" LEVEL "CUSTOMER" IS ("CUSTOMERS"."CUST_ID""
") LEVEL "CITY" IS ("CUSTOMERS"."CUST_CITY") LEVEL "STATE" IS ("CUSTOMERS".""
"CUST_STATE_PROVINCE") LEVEL "COUNTRY" IS ("COUNTRIES"."COUNTRY_ID") LEVEL ""
"SUBREGION" IS ("COUNTRIES"."COUNTRY_SUBREGION") LEVEL "REGION" IS ("COUNTRI"
"ES"."COUNTRY_REGION") LEVEL "GEOG_TOTAL" IS ("COUNTRIES"."COUNTRY_TOTAL") L"
"EVEL "CUST_TOTAL" IS ("CUSTOMERS"."CUST_TOTAL") HIERARCHY "CUST_ROLLUP" ("C"
"USTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "CUST_TOTAL") HIERARCHY "
""GEOG_ROLLUP" ("CUSTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "COUNTR"
"Y" CHILD OF "SUBREGION" CHILD OF "REGION" CHILD OF "GEOG_TOTAL" JOIN KEY (""
"CUSTOMERS"."COUNTRY_ID") REFERENCES "COUNTRY") ATTRIBUTE "CUSTOMER" DETERMI"
"NES "CUSTOMERS"."CUST_FIRST_NAME" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMER"
"S"."CUST_EMAIL" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_MAIN_PHON"
"E_NUMBER" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_POSTAL_CODE" AT"
"TRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_STREET_ADDRESS" ATTRIBUTE ""
"CUSTOMER" DETERMINES "CUSTOMERS"."CUST_CREDIT_LIMIT" ATTRIBUTE "CUSTOMER" D"
"ETERMINES "CUSTOMERS"."CUST_INCOME_LEVEL" ATTRIBUTE "CUSTOMER" DETERMINES ""
"CUSTOMERS"."CUST_YEAR_OF_BIRTH" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS""
"."CUST_MARITAL_STATUS" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_GE"
"NDER" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_LAST_NAME" ATTRIBUT"
"E "CITY" DETERMINES "CUSTOMERS"."CUST_CITY" ATTRIBUTE "STATE" DETERMINES "C"
"USTOMERS"."CUST_STATE_PROVINCE" ATTRIBUTE "COUNTRY" DETERMINES "COUNTRIES"."
""COUNTRY_NAME" ATTRIBUTE "SUBREGION" DETERMINES "COUNTRIES"."COUNTRY_SUBREG"
"ION" ATTRIBUTE "REGION" DETERMINES "COUNTRIES"."COUNTRY_REGION" ATTRIBUTE ""
"GEOG_TOTAL" DETERMINES "COUNTRIES"."COUNTRY_TOTAL" ATTRIBUTE "CUST_TOTAL" D"
"ETERMINES "CUSTOMERS"."CUST_TOTAL""
哪位可以解决以上问题
"CREATE DIMENSION "CUSTOMERS_DIM" LEVEL "CUSTOMER" IS ("CUSTOMERS"."CUST_ID""
") LEVEL "CITY" IS ("CUSTOMERS"."CUST_CITY") LEVEL "STATE" IS ("CUSTOMERS".""
"CUST_STATE_PROVINCE") LEVEL "COUNTRY" IS ("COUNTRIES"."COUNTRY_ID") LEVEL ""
"SUBREGION" IS ("COUNTRIES"."COUNTRY_SUBREGION") LEVEL "REGION" IS ("COUNTRI"
"ES"."COUNTRY_REGION") LEVEL "GEOG_TOTAL" IS ("COUNTRIES"."COUNTRY_TOTAL") L"
"EVEL "CUST_TOTAL" IS ("CUSTOMERS"."CUST_TOTAL") HIERARCHY "CUST_ROLLUP" ("C"
"USTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "CUST_TOTAL") HIERARCHY "
""GEOG_ROLLUP" ("CUSTOMER" CHILD OF "CITY" CHILD OF "STATE" CHILD OF "COUNTR"
"Y" CHILD OF "SUBREGION" CHILD OF "REGION" CHILD OF "GEOG_TOTAL" JOIN KEY (""
"CUSTOMERS"."COUNTRY_ID") REFERENCES "COUNTRY") ATTRIBUTE "CUSTOMER" DETERMI"
"NES "CUSTOMERS"."CUST_FIRST_NAME" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMER"
"S"."CUST_EMAIL" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_MAIN_PHON"
"E_NUMBER" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_POSTAL_CODE" AT"
"TRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_STREET_ADDRESS" ATTRIBUTE ""
"CUSTOMER" DETERMINES "CUSTOMERS"."CUST_CREDIT_LIMIT" ATTRIBUTE "CUSTOMER" D"
"ETERMINES "CUSTOMERS"."CUST_INCOME_LEVEL" ATTRIBUTE "CUSTOMER" DETERMINES ""
"CUSTOMERS"."CUST_YEAR_OF_BIRTH" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS""
"."CUST_MARITAL_STATUS" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_GE"
"NDER" ATTRIBUTE "CUSTOMER" DETERMINES "CUSTOMERS"."CUST_LAST_NAME" ATTRIBUT"
"E "CITY" DETERMINES "CUSTOMERS"."CUST_CITY" ATTRIBUTE "STATE" DETERMINES "C"
"USTOMERS"."CUST_STATE_PROVINCE" ATTRIBUTE "COUNTRY" DETERMINES "COUNTRIES"."
""COUNTRY_NAME" ATTRIBUTE "SUBREGION" DETERMINES "COUNTRIES"."COUNTRY_SUBREG"
"ION" ATTRIBUTE "REGION" DETERMINES "COUNTRIES"."COUNTRY_REGION" ATTRIBUTE ""
"GEOG_TOTAL" DETERMINES "COUNTRIES"."COUNTRY_TOTAL" ATTRIBUTE "CUST_TOTAL" D"
"ETERMINES "CUSTOMERS"."CUST_TOTAL""
哪位可以解决以上问题
解决方案 »
- vs2005 c++编译occi报 error LNK2019: 无法解析的外部符号
- 有一道题a.time是时间字段 取表a的最近一周的最新的一条记录和表a的最近一周的最老的一条记录 各位 怎么算呀
- 求助!!!!!!!!!
- 怎么把RAW(6)数据类型转成10进制的数字?
- PL/sql 如何把结果集显示出来?
- PCTFREE和PCTUSED区别
- Oracle的基础问题!!!
- 使用ORACLE9I的EXTERNAL TABLE功能,文本中有汉字,但是查询出来的是乱码,如何解决?
- 大家好,关于Oracle中“对象权限”的问题?
- SQL server和ORACAL的性能谁好些?????
- Oracle中如何实现自动编号功能
- 如何一次创建多个存储过程,函数,触发器?
http://tips.9hao.com/fanqiang/a2/b2/20011106/171625.html
希望对你有用。