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
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is dcl? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
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?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
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 the role of dip user in our database?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
internal architecture
who owns the operating system files created by the utl_file package?
What happens on checkpoint? : sql server DBA
What the different components in replication and what is their use? : sql server DBA