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
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?
which background process invoke at the time of upgradation tell me???
how can you implement fine-grained auditing?
How to start SQL Server in minimal configuration mode?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How can you control the amount of free space in your index pages? : sql server DBA
what are the types of connection load-balancing?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what are the benefits of flashback feature?
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
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What types of replication are supported in sql server? : sql server DBA
Why would you call update statistics? : 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?
What is dbcc? : sql server DBA