Answer Posted / kd
exec dbms_stats.gather_table_stat (owner, tablename);
or
analyze table xxx estimate statiistics;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is mrc and what is its use? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Are These Dff's Flexible?
Explain the process of recievables in oracle financials. : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Explain how to close periods in ar. : oracle accounts receivable
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.