-
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
-
I dont think you can make that column used again.
Raghu
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|