DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Create Table does not show in Logminer...

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    I was analyzing my Redo Logs and noticed that the create table as select .... does not show up on my Redo Log analysis using Log Miner


    Any reasons why?

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Feb 2002
    Posts
    59
    Logminer only shows DML. No DDL.


  3. #3
    Join Date
    Aug 2001
    Posts
    75
    That's is not correct in 9i. You can see all the DDL statements in logminer.

    Sanjay

    Originally posted by abongwa
    Logminer only shows DML. No DDL.

    OCP 8i

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    This shows why one should not forget to mention the Oracle version when putting in a query. Also the OS.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Thanks a lot guys,

    ALso logminer shows me the database user. But in certain cases a lot of developers have the username/passwrod for the same database user.

    Is there a way to know the O/S user using logminer?

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width