We have Oracle 10g and would like to back it up (everything or all but table record information) but are having a rough time figuring out this mess. I've tried using Enterprise GUI console but it just points me to the console window. I've tried using EXP but get the error:
EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully
The Windows 2000 environment variable:
PATH = C:\oracle\product\10.2.0\client_1\bin
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
How do i go about making a full backup the database without having a phD in rocket science? It baffles me that such an important task is unnecesarrily difficult in Oracle.
Thanks for any quick solutions. Im open to good 3rd party tools. Feel free to provide a step by step too.
Im using Windows 2000, Oracle 10g v10.2.0.