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

Thread: Dba_unused_col_tabs

  1. #1
    Join Date
    Jun 2001
    Location
    Dublin, Ireland
    Posts
    66

    Dba_unused_col_tabs

    Hi,
    Is there any equivalent view in oracle 8.0.6 that would give me the same information as dba_unused_col_tabs in 8.1.7, or is it possible to check if any tables have columns that were SET UNUSED?

    Thanks in advance for any help

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Dba_unused_col_tabs

    Originally posted by bgill
    Hi,
    Is there any equivalent view in oracle 8.0.6 that would give me the same information as dba_unused_col_tabs in 8.1.7, or is it possible to check if any tables have columns that were SET UNUSED?

    Thanks in advance for any help
    SET UNUSED is an 8i feature, I would be surprised if it works in 8.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jun 2001
    Location
    Dublin, Ireland
    Posts
    66
    Thanks Julian for the quick response.

    SET UNUSED is an 8i feature, I would be surprised if it works in 8.
    I was hoping that was the case!

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