Interested to Buy Any Domain ? << Click Here >> for more details...
how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
- 4 Answers
- 9023 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
migration of database we have two ways
1)datapump
2)We can do through package procedure.Create empty database
on target database and create dblink between two
databases.Now we have to prepare
package and transfer the each schema.
3)transportable tablespace ( rman duplicate database / by
manaual standby method)
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)..
Above answers correct.
Now days some best methods are follwed also.
4) Using Oracle streams / Golden Gate ( zero down time)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can you redefine a table online?
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?
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 importance of a recovery model? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what do you understand by fine-grained auditing?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is transparent data encryption? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What the different components in replication and what is their use? : sql server DBA
What is fill factor? : sql server DBA
