Re: Export/Import from 8.x to 7.x problem

Jason,

Two points :-

1. How are you sending the export to the other machine, if by FTP make = sure you send in binary mode.
2. When exporting from the V8 source DB you must first run a SQL script = I can not remember the exact name but some thing like EXPV7 and also = flip it back again when complete.

If you can not find the script mail me (removing <NO SPAM>) and I will = look for it.

Bye,
Martin Speight.
martin_at_aspeight<NO SPAM>.freeserve.co.uk

    Jason Ladew wrote in message =
<36ED5BC5.4388C014_at_esc188.expansion.com>...

    Hello,
    I am exporting a schema owner user from an Oracle8 DB on a Linus box = and importing the user to an Oracle7 DB on AIX (7.3.4). On the import I = get the following errors:

    IMP-00010: not a valid export file, header failed verification     IMP-00021: operating system error - error code (dec 2, hex 0x2)

    Does anyone know why? When I export, should I export it using some = special flag for 8 to 7 conversion? Is there a special EXP or IMP for = loading ver8.x to ver7.x dumps?

    here are the commands I use:

    Export cmd line:
    exp user/pw buffer=100000 file=<dump filename> compress=y = grant=n log=log.log

    Import cmd line:
    imp user/pw buffer=200000 file=<filename> grants=n = log=log.log fromuser=train touser=train3

    please reply to devdewboy_at_hotmail.com

    Thanks,

    jasonl Received on Tue Mar 16 1999 - 12:22:54 CST