Hope you'll had a nice weekend!
1.Say,after I run the Analyze command on Scott.emp table.
Wherein should I look For the analysed statistics for the above table.I mean to say which Table.Should I look into DBA_TABLES.
2.After I run the command:
ALTER DATABASE BACKUP CONTROFILE TO TRACE
Should I run the TraceId File generated in the Nomount stage by doing the following:
which would create the new Control File for me.
Is this Ok!
3.If the DB crashes,could we at least connect as Internal and mount the DB.Is this possible!
4.What are the possible steps to insert Datas into Datawarehousing Tables like Dimension Tables,Fact Tables,etc.,
What tools should we use for the above to insert datas.
why you dont try it on a test database?
It wouldnt hurt if you have some reading on Oracle docos too
Click Here to Expand Forum to Full Width