how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
Answer Posted / sanjayreddy
migration of database we have two ways
1)datapump
2)transportable tablespace
so we can copy/migrate the data by using 2 method from one server to another server like(linux to sun solaris or vis/versa)..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the use of ocr?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
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.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Which autogrowth database setting is good? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you enable flashback feature?
What the different types of replication and why are they used? : sql server DBA
what are the performance views in an oracle rac environment?
what is a user-defined lock?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is fill factor? : sql server DBA
What is the default fill factor value? : sql server DBA