Need help exporting and importing

[Quoted] [Quoted] I am using Oracle 8.0.3 enterprise server running under NT4.0. I want to export all the data contained in a set of tables owned by a particular user and import the data into another instance of the same setup (i.e. 803 on NT4.0) located on another physical machine. I have read the docs but can't get it to work. Some questions:

[Quoted]
1. The docs say to run a command "exp ......". Where do I run this? IT doesn't work in SQL*Plus. [Quoted]
2. What is the simplest form of the above command that I can use? [Quoted]
3. Who should I be logged on as when I do the above export?
4. Who should I be logged on as when I do the import? [Quoted]
5. Is it just me or does the "export" menu option on Data Manager just not work? [Quoted]
6. Should I have created the user that owns the tables on the machine I'm importing to before I begin importing?

[Quoted] As you can see I am very confused about all of this. All help greatly appreciated.

Thanks,

Ciaran O'Maonaigh Received on Wed Nov 05 1997 - 00:00:00 CET