Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Copy tables from oracle 7 to oracle 9

Copy tables from oracle 7 to oracle 9

From: <mdurliSPAMFILTER_at_hotmail.com>
Date: Wed, 11 Sep 2002 15:39:23 GMT
Message-ID: <6mounuctsr4ngapj3g8mc14lv9j9su0vo1@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 Wed Sep 11 2002 - 10:39:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US