• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1107
  • Last Modified:

Can Oracle attach database as MS SQL Server can do.

I have th database in oracle on one pc now i have to move that database to another oracle server how i can move that

as in MS-sql we attach the database

Please help
  • 4
2 Solutions
>> i have to move that database to another oracle server

     are you upgrading or in same version?

      if in same version, tts (trasportable tablespace) is an option.

     if upgrading, imp/exp would be  another option.
njtdAuthor Commented:
both oracle are same version.
Can you please tell me step by step because i'm oracle newbie
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

assume you are in oracle8.

Mark GeerlingsDatabase AdministratorCommented:
Be aware that the term "database" means something different in Oracle than in SQL Server!  In Oracle, a "database" (or instance)  is the complete system.  In SQL Server, a "database" is just one part of the complete system.

Also, SQL Server comes from a company that specializes in producing software tools, so their tools are quite easy to use.  Oracle is a company that makes a great database (and that database can run on most operating systems!)  but the Oracle tools are not as easy to use as the SQL Server tools.

Basically, if you want to copy an entire Oracle database from one server to another, it is not so difficult.  You just shut the database down, then copy all of the: data, log, control and init files to the other server (preferably into identical file locations) then if you have the same version of the Oracle database software installed there, you just start the database there.
good point.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now