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
- 9189 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravindra
Hi,
Correct if i am wrong.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.
Thanks & Regards,
Ravindra
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / 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 |
How would you go about verifying the network name that the local_listener is currently using?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you find out if a table can be redefined?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the operating modes in which database mirroring runs? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
What command would you use to encrypt a PL/SQL application?
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 is difference between user managed backup and rman backup?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
