How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?
Answers were Sorted based on User's Feedback
Answer / snaukak
For Oracle 10g and higher you can try to use datapump.
It is much faster as runs on server only.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ron
use transportable tablespace
click on the link below for doing it with examples:
http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_5.shtml
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What is a proxy object?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How will you write a query to get a 5th rank student from a table student_report?
What is a table index?
am completed mca2011 how get certification in oracle
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
what is candidate key & super key
What is recovery manager(rman) backup in Oracle?
What is a Temporary Segment ?
What is an oracle user account?