Re: Copy tables from oracle 7 to oracle 9

Yout truly -desperately- need to read the Oracle concepts guide.

Oracle is NOTHING like SQL Server. They are both databases, and that's about it. Forget everything you learnt about what a "database" is, and read up on Oracle tablespaces and schemas instead.

Do not attempt to use your SQL Server knowledge in an Oracle context. You will be lead astray, and sent down dead ends without paddling instruments, just to mix a metaphor or three.

Honestly: you cannot do Oracle if all you have is SQL Server knowledge. You need to beef up a bit first. It;s not that one is necessarily better than the other, but that they are so completely dissimilar. Even the word 'database' means different things to each product.

Visit technet.oracle.com, sign up for a free account, download the concepts guide, and read and inwardly digest. Then we can talk turkey.

Regards
HJR <mdurliSPAMFILTER_at_hotmail.com> wrote in message news:6mounuctsr4ngapj3g8mc14lv9j9su0vo1_at_4ax.com...
> Hello,
> I'm completely new to Orcale, and I need to develop an application in
> CBuilder (windows) that reads very simple data from an Oracle 7
> database on UNIX.
> No problem with this, only I want to go to my client and copy the db
> (a few tables) on my laptop to work at the office.
> I downloaded and installed oracle 9i personal edition on the laptop,
> but I have no idea on how to copy the tables from db to db.
> I always worked with SQLServer, and the entreprise manager is quite
> similar, only when I go to export/import data the em ask me to log to
> oracle managment server to do it, I try with the system/mypassword but
> it doesn't work. But what is the oracle management server?
>
> Then I'm a little bit confused:
> In SQLServer Enterprise manager I'm used to have in the tree, first
> the server with the instance, then the databases contained (system..+
> my databases) and in each database the tables,indexed, stored p. ecc
> ecc
> Is possible to have a view like this in Oracle? I've found the tables
> of the scott/tiger example under schema, but I don't think is the
> right way.
>
> Anyone can help me?
>
> Thanks!
>
Received on Fri Sep 13 2002 - 08:28:00 CDT