How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?
Answer Posted / pugal
You can import and export data with the "Schema Manager"
GUI that ships with Oracle Enterprise Manager (OEM).
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to test null values?
What is oracle instant client?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
State all possible different index configurations a table can possibly have?
What is a sub query? What are its various types?
Explain table?
What are the differences between number and binary_float in oracle?
Is primary key indexed by default in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain the use of show option in imp command.
What is a read write transaction in oracle?
List out the difference between commit, rollback, and savepoint?