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
njtdAsked:
Who is Participating?
 
actonwangConnect With a Mentor Commented:
>> 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
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
actonwangCommented:
assume you are in oracle8.

0
 
Mark GeerlingsConnect With a Mentor Database 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
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.

All Courses

From novice to tech pro — start learning today.