Hi all!

Hope you'll had a nice weekend!

Query:

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:

SVRMGR>@C:\oracle\oradata\admin\dbname\Tracefile

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.


Thanks&Regards

Amit.