Home » RDBMS Server » Server Utilities » Is EXP80 still valid for Export in 8.1.7
Is EXP80 still valid for Export in 8.1.7 [message #74180] Wed, 29 September 2004 06:04 Go to next message
saustin
Messages: 43
Registered: June 2003
Member
Hi,
   Is EXP80 still a valid option for a full Export in 8.1.7 ? Ran it and it seemed to complete just fine. Would love to keep using it as we did in 8.05.

Many thanks, Steve.

Report message to a moderator

Re: Is EXP80 still valid for Export in 8.1.7 [message #74220 is a reply to message #74180] Wed, 13 October 2004 06:13 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

You need to use the 8.1.7 "EXP.EXE" utility. The old EXP80.EXE utility might still work, but it cannot deal with the 8.1.7 feature set.

Best regards.

Frank

Report message to a moderator

Re: Is EXP80 still valid for Export in 8.1.7 [message #74221 is a reply to message #74220] Wed, 13 October 2004 07:13 Go to previous message
saustin
Messages: 43
Registered: June 2003
Member
Hi Frank,
Many thanks for the reply ! Have tested an export using the old EXP80 but did not do an IMPORT of the dmp file to complete the test. Have just looked at the doc's and will analyze the parfile further.

Our existing

File=E:DUMPBACKVMFG.DMP
USERID=SYSTEM/MANAGER
FULL=Y
DIRECT=Y
LOG==E:DUMPBACKEXPLOG.LOG

Should be changed to

File...
USERID...
GRANTS=Y
FULL=Y
ROWS=Y

For a full back (which we do on a nightly basis).

Appreciate the major tip. Steve.

Report message to a moderator

Previous Topic: migration inside Oracle
Next Topic: SQL Loader Parameters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 08:18:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.