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

Thread: unused column

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    hi everybody,
    the problem is
    if i marked a column of a table as unused due to some reasons but now i want to use that column again .can any body tell me the syntax
    thanks in advance
    pras

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    I dont think you can make that column used again.
    Raghu

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    In Oracle 8i,once u make a column unused u cannot bring the column again.U can also not fire a query statement against that column nor the column is viewed in the table definition.But u can add a column with the same name again in ur table.In ur case if u want the column again I think that u should go for import of the table from the last export.
    In case of any doubts,please be free to ask to me at rohitsn@hotmail.com

    regards,
    Rohit Nirkhe,Oracle DBA,OCP

  4. #4
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    hi
    thanks a lot to both of u raghu and rohit
    regards
    pras

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