Re: Copy tables from oracle 7 to oracle 9

From: Justin Cave <jocave_at_yahoo.com>
Date: 11 Sep 2002 17:26:40 -0700
Message-ID: <233b7a65.0209111626.6125d0ef@posting.google.com>

mdurliSPAMFILTER_at_hotmail.com wrote in message news:<6mounuctsr4ngapj3g8mc14lv9j9su0vo1_at_4ax.com>...
> 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.

What SQLServer refers to as a 'database' is generally referred to as a 'schema' in Oracle. What SQLServer refers to as an 'instance' is generally referred to as a 'database' in Oracle.

So, if you found the scott schema, you've found the database (SQLServer sense) you're looking for.

Justin Received on Wed Sep 11 2002 - 19:26:40 CDT