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 |
Explain the use of show option in imp command.
What to do if the binary spfile is wrong for the default instance?
What are steps required to ENTER DATA INTO DWH?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
How to define a data source name (dsn) in odbc manager?
What is merge in oracle?
What is an oracle wallet?
How to start an oracle instance?
what is a cartition product?
Can we create more than one constraint to column ?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to get a list of all background sessions in the database?