SQL> show user
USER is "ORACLE"
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
SQL> CREATE GLOBAL TEMPORARY TABLE TEMPXML OF XMLTYPE
2 ON COMMIT PRESERVE ROWS
3 NOCACHE;
Table created.
SQL>
Is it allowed to create temp table with XML option in ORACLE 9.0.1.1.1 ?????????