upgrade it as follows
*EXAM OBJECTIVE: CREATE THE SYSAUX TABLESPACE*
UNDERSTANDING THE SYSAUX TABLESPACE
In Oracle 10g, we have the introduction of a new SYSAUX tablespace. This
tablespace is an auxiliary tablespace to the SYSTEM tablespace.
• This tablespace is a mandatory tablespace that always gets created when
the
database is created. Some database components that formerly created and used
separate tablespaces now occupy the SYSAUX tablespace
• The SYSAUX tablespace is a permanent tablespace which is enabled read-
write. It is always a locally managed tablespace with segment space
management defined as AUTO.
• The SYSAUX tablespace provides a centralized repository for all auxiliary
database
metadata that does not reside in the SYSTEM tablespace.
OCCUPANTS OF THE SYSAUX TABLESPACE
The tables displayed below gives you an idea of various features of the
database
that now use the SYSAUX tablespace, that earlier might have created their
own
tablespaces.
OCCUPANT
ORIGINAL TABLESPACE
Text, Ultra Search
DRSYS
Intermedia, Spatial
SYSTEM
Scheduler
New in Oracle 10g
OLAP
CWMLITE
XML DN
XDB_RESINFO
Workspace Manager
SYSTEM
Data Mining
ODM
Server Manageability Components
New in Oracle 10g
Recovery Catalog
TOOLS
EM Repository
OEM_REPOSITORY
Analytical Workspace Object table
SYSTEM
LogMiner, Log Standby, Streams
SYSTEM
Statspack
User defined
*CREATING THE SYSAUX TABLESPACE*
The SYSAUX tablespace may be created using the
• *CREATE DATABASE *command. In this command the clause SYSAUX
DATAFILE has been introduced.
*OracleSource.net*
1

Dears,
thanks alot for your replies , but I didnt get you the question is how to troubleshoot the error and continue step by step
Incorrect environment file sourced. Unset apps
and source RDBMS oracle home environment file.

like
#1) Unset apps ... what to do ?
#2) source RDBMS oracle home in enviroment file .. what to do ?
I have make in env file ORACLE_HOME = f:\oracle\prodora\8.0.6
RDBMS ORACLE_HOME = f:\oracle\proddb\10.0.4
but still raising me same error ...
my system is windows having both the apps tier and dbs tier at same Server.
Ali Haddawi

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.