Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. C4IAaron

    How to shrink user temp datafile

    I believe you can reclaim space from the datafile by: alter database datafile 'db01/oracle/cc/data01.dbf' resize 80m; of course you can't reclaim space that is allocate to another object. But I hope this helps! Aaron
  2. C4IAaron

    Creating Redo Log Files

    Hi There, I am new to the DBA world, so please forgive me simple question... I would like to set up three redo log files and then of course set the database to archivelog mode. I know how to put the database into archivelog mode and specify the directory for the redo files but don't know if I...

Part and Inventory Search

Back
Top