Blocksize for Datafiles,Redo log files and Control files

Few times this question passed by my mind but don't know why i never thought much over it -  "Are the block sizes for the datafiles,redo log files and control files the same".Thanks to Aman, for writing on it, in his blog.Simple and well explained.Definitely, read it 🙂 http://blog.aristadba.com/?p=124

ORA-600[2130], [2], [1], [2]

I had an interesting case of ORA-600 [2130], [2], [1], [2] few days back, which i am going to share in this post 🙂 As part of Oracle streams setup , a downstream capture database was created by me manually. What is Downstream Capture Database ???With Oracle 10g,it is possible to configure the capture process …

EXPDP – exclude parameter

There seems to be some confusion with the "EXCLUDE" clause in expdp.The confusion is,when a schema level expdp is taken with few table names(one or more) in the exclude parameter and  imported, these excluded tables will be created (metadata only) but won't have data.It means even if we exclude the tables while export, its metadata …