By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,195 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,195 IT Pros & Developers. It's quick & easy.

Migrating questions

P: n/a
vv
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
vv
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 <hf******@yahoo.net> wrote in message news:<40***************@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

Jul 19 '05 #3

P: n/a
vv wrote:

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?


Go to http://otn.oracle.com and click on the icon marked 'Documentation"
at the top of the page. (Alternate access - http://docs.oracle.com)

Select your database version (hopefully Oracle9i Release 2), then click
on 'List of Books' link. ALL available Oracle database docco is listed
then in alpha order. Select the 'Concepts' manual.

Alternate reading is from O'Reilly publishing - Oracle Essentials for
Oracle8 to Oracle9i. More details at http://oreilly.oracle.com

Other useful information - http://otn.oracle.com/obe/start/index.html
for samples

HTH
/Hans
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.