how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
Answer Posted / venu
It can be done thru hot cloning
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is a user-defined lock?
What are the steps you will take to improve performance of a poor performing query?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Why does Oracle not permit the use of PCTUSED with indexes?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the commands you'd issue to show the explain plan for "select * from dual"?
What authentication modes does sql server support? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Where do you find the default index fill factor and how to change it? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?