Oracle Common Errors-ORA-00904

11g-exp ORA-00904: "maxsize": the identifier is invalid 1. exception D:/> exp user/pass @ host file = 'd:/expdata 'tables = T export: Release 11.1.0.7.0-production on Friday, December 13, 2008 14:19:41 copyright (c) 1982,200 7, Oracle. all rights reserved. connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit production with the partitioning, OLAP and Data Mining options exported zhs16gbk Character Set and al16utf16 nchar The character set server uses the al32utf8 character set (possible Character Set conversion) to export the specified table through the regular path ..... exporting table t EXP-00008: encountered Oracle error 904 ORA-00904: "maxsize": identifier invalid EXP-00008: encountered Oracle error 942 ORA-00942: Table or view does not exist EXP-00024: Export view not installed, please inform your DBA EXP-00000: Export termination failed 2. SQL> select distinct table_name from user_col_comments where column_name = 'maxsize'; table_name comment exu9stou exu9plb exu9pd Su exu9lbcpu exu9tpexu9ixcp cpool $ exu9tbcpu exu9tbcp exu9sto exu9ixcpu table_name quota dba_cpool_info exu9tbs exu9bu plexu9lbcp has selected 15 rows. #10g Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit production with the partitioning, OLAP and Data Mining options SQL> DESC SYS. exu9tbs name is blank? Type ----------------------------------------- -------- ---------------------------- id not null number owner char (6) name not null varchar2 (30) isonline varchar2 (7) content varchar2 (9) iniext not null number sext not null number pctinc not null number minext not null number maxext not null number minlen number deflog not null number ext_mgt not null number alloc_type not null number blocksize not n Ull number #11g Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-production with the partitioning, OLAP and real application testing options SQL> DESC sys. exu9tbs name is blank? Type ----------------------------------------- -------- ------------------------- id not null number owner char (6) name not null varchar2 (30) isonline varchar2 (7) content varchar2 (9) iniext not null number sext not null number pctinc not null number minext not null number maxext not null number minlen number deflog not null number ext_mgt not null number alloc_type not null number blocksize not null number maxsize number ------------------> the problem was not found in Metalink in problem query, it should be a bug. Keep up with the document note: 132904.1 Compatibility Matrix for export and import between different Oracle versions