RE: RMAN Report question

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Thu, 15 Jul 2004 19:15:19 -0700 (PDT)
Message-ID: <20040716021519.8999.qmail@web50603.mail.yahoo.com>

Hi Mike,

Thanks!

I made a stupid SQL syntax mistake which did not create my table with nologging, e.g. we should put nologging right after the table/tablespace name instead of at the end of your statement. My nologging became a very nice table alias, nothing more. ;-)

I've corrected my bad behaviour by writing queries to check for nologging objects in dba_indexes, dba_tables, your v$datafile example is great, and checking redo generated by SQL in v$mystat.

Regards,

Mike Thomas

• Mike Killough <mwkillough_at_hotmail.com> wrote:
  > It works for me (9.2.0.4 / Sun):
  >
  > R7ORACLE:system:r7orcl1> create table scott.emp_tmp2
  > tablespace users
  > nologging as select * from scott.emp;
  >
  > Table created.
  >
  > R7ORACLE:system:r7orcl1> SELECT name, status,
  > UNRECOVERABLE_CHANGE#,
  > 2 TO_CHAR(UNRECOVERABLE_TIME, 'mm-dd-yyyy
  > hh:mi:ss')
  > unrecoverable_time
  > 3 FROM V$DATAFILE
  > 4 WHERE unrecoverable_time > sysdate - 1;
  >
  

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 15 2004 - 21:11:52 CDT