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 |
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
How to turn on or off recycle bin for the session?
Explain the difference between a procedure and a function? What do you understand by those terms?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
What are the predefined tablespaces in a database?
what is the syntax of INSERT command?
How to select all columns of all rows from a table in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Explain the blob datatype?