Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Copy tables from oracle 7 to oracle 9
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 Wed Sep 11 2002 - 10:39:23 CDT