Migrating questions

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • vv

    Migrating questions

    Hi All,
    I'm a newbie in databases..and I'm looking for answers for a few questions...
    Any help is appreciated!
    1.What do you mean by importing a databse?
    2.Is it possible to import Sybase databse to Oracle databse?
    3.Do I need Sybase database to migrate data to Oracle Database?
    4.When i use import utility , will oracle create all the tables?

    If the above questions are not clear, pl give as much info as you can...
    because that's how the questions have been put to me

    Thanks in advance
    VV
  • Hans Forbrich

    #2
    Re: Migrating questions

    vv wrote:
    >
    Hi All,
    I'm a newbie in databases..and I'm looking for answers for a few questions...
    Any help is appreciated!
    1.What do you mean by importing a databse?
    Loading the exported data into a database. Export is an Oracle utility
    designed to extract data from the database an place it into a
    custom-formatted export file for import later on.
    2.Is it possible to import Sybase databse to Oracle databse?
    No
    3.Do I need Sybase database to migrate data to Oracle Database?
    Yes. Or at least an extract with a known format that can be mapped.
    4.When i use import utility , will oracle create all the tables?
    Yes.
    >
    If the above questions are not clear, pl give as much info as you can...
    because that's how the questions have been put to me
    >
    Go to Oracle's online documentation (at http://otn.oracle.com >>
    Documentation [icon at top]) and look for the list of manuals. Dig out
    the Utilities manual (gives details of export and import) and the
    Concepts manual (look at the table of contents for interesting
    chapters.) Then you will have a better understanding of the questions
    you asked.
    Thanks in advance
    VV

    Comment

    • vv

      #3
      Re: Migrating questions

      Thank you Hans..
      That was helpful...
      Can u suggest where I can find information on DBMS concepts../Oracle
      basics...like how the database is stored...what is schema/objects etc?

      Hans Forbrich <hforbric@yahoo .netwrote in message news:<400D5BAB. B6D7F674@yahoo. net>...
      vv wrote:

      Hi All,
      I'm a newbie in databases..and I'm looking for answers for a few questions...
      Any help is appreciated!
      >
      1.What do you mean by importing a databse?
      >
      Loading the exported data into a database. Export is an Oracle utility
      designed to extract data from the database an place it into a
      custom-formatted export file for import later on.
      >
      2.Is it possible to import Sybase databse to Oracle databse?
      >
      No
      >
      3.Do I need Sybase database to migrate data to Oracle Database?
      >
      Yes. Or at least an extract with a known format that can be mapped.
      >
      4.When i use import utility , will oracle create all the tables?
      >
      Yes.
      >

      If the above questions are not clear, pl give as much info as you can...
      because that's how the questions have been put to me
      >
      Go to Oracle's online documentation (at http://otn.oracle.com >>
      Documentation [icon at top]) and look for the list of manuals. Dig out
      the Utilities manual (gives details of export and import) and the
      Concepts manual (look at the table of contents for interesting
      chapters.) Then you will have a better understanding of the questions
      you asked.
      >
      Thanks in advance
      VV

      Comment

      Working...