Gopal,
Thanks. Yes , as per names it looks like temporary but it does stay even
after database is rebounced. What do you mean by NULL tablespace?
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 11 Jun 2001 13:50:53 -0800
Hi
There is not a lot of documentation in the Oracle 8.1.5 Server
Reference Manual on this column. I know that this logging
column in DBA_TABLES view can be set to YES, NO, and NULL.
What kind of logging are we talking about? Redo logs?
We're running 8.1.5 on Sun Solaris 2.6. This is a
Gopal,
How about this:
1* select owner,table_name, logging from dba_tables where logging != 'YES'
SQL /
OWNER TABLE_NAME LOG
-- -- ---
SYSATEMPTAB$
Hi Mohammad !
They all are **temporary** tables and (have you
checked the definition) in the NULL tablespace. So it
is perfectly normal :)
--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
Gopal,
How about this:
1* select owner,table_name, logging from dba_tables
where logging != 'YES'
SQL /