asked on

ORacle 9i table backup

How can I a backup tables which are big, that is more than 125 GB?
I tried using the exp utility without any success.
Can somebody give me steps to do this and the imp steps too..
Note: The export has to be from a 9i database and import will be done in 11g database.

Thanks@

slightwv (䄆 Netminder)

Why did exp fail? export file to large?

What OS?

D-pk

ASKER

These were the errors I got..

EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

I am able to do smaller tables, but the tables which 125GB, it gives me the above errors.
OS is Linux. (I gave uname -a, if that is correct)

Thanks@

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

D-pk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

>>does the windows system has that restriction?

It shouldn't but you have network lag time built into the time.

>>ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

You need to use a database alias from your tnsnames.ora file. If you don't know how to configure your client, it will need to be a separate question.

SOLUTION

gopisera

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

D-pk

ASKER

Thanks