Does Oracle 4.3 have export utility?
-Original Message-
Sent: Tuesday, April 30, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L
Hi friends,
Iam exporting some of tables, but keep getting error!! Could you help.. Mine
is AIX415 with oracle4.3, If I want import an individual tab
Just run like this. It will ask for password. Assuming you are running it
manually.
Make sure you have ORACLE_SID set correctly.
exp user FULL=N tables = ( table1, tab2, tab3,
tab40,tab5,ttdsls051061,ttdsls051110,ttdsls051120,ttdsls051130,
ttdinv700040,ttdinv700061,ttdinv700110,ttdinv700120,t
Basing it on my Solaris experience the \ is a control character so the
system will treat the ( and ) as part of the export command. But doesn't it
need to be immediate before the ( and )? I.e., \( instead of \ (?
What is the error you're getting?
-Original Message-
Sent: Tuesday, April
Raghu
Still do you want to send your export dmp to tape or on disk.
Much better to study Oracle Utilities Manual for complete understanding.
For short type exp (or imp) help=y on unix prompt and you will find
all options available with your oracle release.
To export on tape (for 7.3.4)
exp
Raghu - I notice that your command string extends over several lines.
Perhaps you should consider putting your export parameters into a parameter
file. I can send you an example if that would help.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, Ap
I'm not working on AIX,
but I use syntax
exp user/passwd tables=(TABLE1,TABLE2) ... etc.
Why do you use \( and \) ?
JP
On Tue 30. April 2002 21:38, you wrote:
> Hi friends,
>
> Iam exporting some of tables, but keep getting error!! Could you help..
> Mine is AIX415 with oracle4.3, If I want im