| 2 Node RAC 9.2.0.6 Sun OS 2.8
We created new undo tablespaces (UNDO3 UNDO4) for each node1 and
node2 respectively and changed default undo tablespace to UNDO3 and
UNDO4. Then we put old UNDO tablesHi
Your db can 't work properly with sysaux offline.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C \Documents and Settings\Administrator >sqlplus / as sysdba
SQThis seems to work but the situation has to be right...I have the big table ONLY in this tablspace.
EXPort OFFLINE TABLESPACE Test
SQL > select TABLESPACE_NAME STATUS from dba_tablespaces where Bryan 2C
If you are running in archivelog mode and have all archivelogs
since the datafiles were created 2C then you can create the
datafiles and recover them completely even without a backup 2E
Oracle didn 't create that segment in the datafile... The segment that
used to exist in the old datafile is still referenced in the data
dictionary... However the actually physical segment does |
|
