ORACLE Tips

ORACLE Tips

Q) How can I drop tablespace if a datafile is missing?

Ans)
startup mount
alter database datafile '/path/to/filename' offline drop;
alter database open;
drop tablespace tbsp_name including contents cascade constraints;

Info regarding smart and auto pointers

CPP Smart Pointers :
http://ootips.org/yonat/4dev/smart-pointers.html
http://www.csc.lsu.edu/~kosmas/smartPointers.html

CPP Auto Pointers :
http://www.cplusplus.com/reference/std/memory/auto_ptr/auto_ptr/
http://www.gotw.ca/publications/using_auto_ptr_effectively.htm

This is my first blog which is going to be a test blog