Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Found 2 tips, Displaying 1 - 2 
 
Sort by 
 
 ASM empty directory doesn't get removed, error ORA-15177
The solution is provided in Metalink note ID 444812.1, in short: either re-create the disk group - or - create a dummy tablespace in the directory you are trying to remove and then drop the tablespace, it should also remove the directory
 More...
08/08/11
 
 
 Script to generate sql to enable autoextend on all datafiles
SQL> set head off pagesize linesize 200 SQL> select 'alter database datafile ' || '''' || file_name || '''' || ' autoextend on maxsize unlimited;' from dba_data_files where tablespace_name not like 'UNDO%';
 More...
05/18/11
 
 


Recent tips & tricks
Databases > Oracle > Performance Tuning : ITL waits
Mobile Phones / Tablets > Android : smb not working with Samsung G...
Databases > Oracle > Performance Tuning : When and what's been analyzed
Databases > Oracle > Performance Tuning : Sessions, transactions and rol...

More categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Mobile Phones / Tablets | Office Software
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com