Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1105
  • Last Modified:

Can Oracle attach database as MS SQL Server can do.

Hi
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
0
njtd
Asked:
njtd
  • 4
2 Solutions
 
actonwangCommented:
>> 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.
0
 
njtdAuthor Commented:
both oracle are same version.
Can you please tell me step by step because i'm oracle newbie
Thanks
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
actonwangCommented:
assume you are in oracle8.

0
 
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.
0
 
actonwangCommented:
good point.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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