ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
How to transfer database(500 gb) of oracle enterprise
edition to standard edition downtime is only 1 hour not
using exp/imp option ?
 Question Submitted By :: Patilshashi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
Answer
# 1		 
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
Pugal
 
  Re: How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
Answer
# 2		 
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
Ron
 
 
 
  Re: How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
Answer
# 3		 
For Oracle 10g and higher you can try to use datapump.
It is much faster as runs on server only.
 
Is This Answer Correct ?    0 Yes 0 No
Snaukak
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
what is difference between table and view? where to use views? thanks in advance!  1
Describe Referential Integrity ?  1
how to truncate date and get only time part 9:20:00  4
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)? ESS1
what are the different types of cursors? explain?  3
what are the database links ?  2
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement. Polaris3
What is a data segment ?  1
what are the advantages of running a database in NO archive log mode?  1
What is Row Chaining ?  2
What is the difference between implicit index and explicit index? TCS1
what is the difference between UNION AND UNIONALL  2
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?  1
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL  1
What is a Database instance ? Explain?  2
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks. Excel2
In Oracle 9i what does "i" Stands for? MBT18
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3  2
Please explan Why static query is more faster than dynamic query ?  2
What is a Data Segment ?  2
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com