Re: Need help exporting and importing
Date: 1997/11/05
Message-ID: <63pkuq$fnq$1_at_talia.mad.ibernet.es>#1/1
Hi,
"Ciaran P O'Maonaigh" <CIARANO_at_prodigy.net> wrote:
>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:
>1. The docs say to run a command "exp ......". Where do I run this? IT
>doesn't work in SQL*Plus.
You must open a MS-DOS session, change your current directory to
C:\ORANT\BIN (assuming you have you Oracle tools installed on drive C,
directory ORANT) there you should have "exp80.exe" which is the
program you look for
>2. What is the simplest form of the above command that I can use?
"exp80 file=xxxxxxxx.dmp" where xxxxxxxx is a name you like to the
file; the program then asks you for a user and a password and begins
the exportation of all the tables, indexes,views,etc. which belongs to
the user. Try "exp80 help=y" for a brief help description
>3. Who should I be logged on as when I do the above export?
[Quoted] I usually log as the user from which I want to export data, but you
could do the same by using a line command option (maybe "fromuser",
not sure right now) and loggin as a user with enough privileges to
export the full database, as SYSTEM for instance.
>4. Who should I be logged on as when I do the import?
I do it as SYSTEM and using the command line options "fromuser=X
touser=Y" where X is the user from wich I did the export and Y the one
who is going to receive the import.
>5. Is it just me or does the "export" menu option on Data Manager just not
>work?
Hmm, the Oracle Enterprise Manager tools are great for seeing what you
are working with, but some of them work better in the "old-but-good"
DOS mode command line :)
>6. Should I have created the user that owns the tables on the machine I'm
>importing to before I begin importing?
Yes, I think so. And be sure to give him enough space to do the
import, I mean Tablespace big enough or set the "Unlimited tablespace"
option.
>As you can see I am very confused about all of this. All help greatly
>appreciated.
>Thanks,
>Ciaran O'Maonaigh
Hope something of this helps you, regards,
Rafa Flores Yoldi
cesinsl_at_redestb.es
Received on Wed Nov 05 1997 - 00:00:00 CET