what r tyhe major differences between oracle 9i & 10g?
Answers were Sorted based on User's Feedback
Answer / sonali
oracle 10g has introduced data pump,awr addm etc
Is This Answer Correct ? | 25 Yes | 3 No |
Answer / krishna
oracle 10g has many features compare to 9i like
asm,swr,addm,flaskback recovery,data pump..
generating snap shot is much more flxible in 10 g compare to 9i
Is This Answer Correct ? | 21 Yes | 3 No |
Answer / ramesh
ASM,procative performance monitoring,initialization
parameter add and absolute(sga_target).
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / paaru ninar
The main differences b/w oracle 9i and 10g both are one and
the same but 10g has some additional features like RECYCLE
BIN (like purge and flashback) and IIMESTAMPS
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ranjith
first you read properly then give your ideas plz
Is This Answer Correct ? | 5 Yes | 2 No |
How to call a stored function in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
13. Display the second to fifth characters in each client name.
How to insert multiple rows with one insert statement in oracle?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
Where do you use decode and case statements?
What is an Oracle index?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
What is a sub query and what are the different types of subqueries?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What is max rowid in oracle?