-
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.
-
why you dont try it on a test database?
It wouldnt hurt if you have some reading on Oracle docos too
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|