Hi,

Oracle 10.1 on Windows
The DB is in NOARCHIVELOG mode.
* How would I check whether the tables that are in the DB, were created
using NOLOGGING or not?
* I need to be sure that even the Partitioned Tables have NOLOGGING set
on them.
* If there are any regular Tables/Partitioned Tables created that do
not have NOLOGGING set, how would I set the NOLOGGING option to them.


Thanks,
vick


Oracle LazyDBA home page