exp/imp !

[jonybd]

how could i use exp/imp for backup Oracle database.

From where i will execute exp/imp ?
Command promt or sql *Plus. !

 

[Turkbear]

Hi,
Read some more on backup strategies but you can use EXP/IMP for 'point in time' backups..

It is a Command line progtram located in
<oracle_home>/bin

But, please read the docs first...

 

[sybaseguru]

To backup a full database and assuming that you trying to learn (i.e. you are not in production) go to any directory with fair amount of space (you know how big is your database) and do the following:

oracle@linux:/home/oracle/mydb/dba/log% $ORACLE_HOME/bin/exp system file=mydb.dmp log=mydb.log full=yes

Export: Release 9.2.0.1.0 - Production on Wed Jul 2 22:52:42 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export the entire database ...

Where file=mydb.dmp is the dump file and log=mydb.log is the log file of the output. full=yes means that you want to export all the database (schemas and data).
However, before embarking on any serious adventure as suggested read the documentation please.

good luck

 

[jonybd]

sybaseguru (Instructor): thanks

I am trying to use Front end MSVC++ , and Back end ORacle 8 enterprise edition. Everything is fine adding , editing , deleteing , saveing.

now my another step remain which is backup.

we all know that $oracle_home\bin\exp or imp
exist. and we can do or get help by doing exp help=yes.

'================================'
'=====But the problem is ========'
'================================'
after installing oracle 8 enterprise edition
why my $oracle_home\bin\exp80 or imp80 ?
where it should be
$oracle_home\bin\exp or imp
why the 80 is joined with that ?

 

[sybaseguru]

I assume that someone who installed the oracle client library renamed the excecutables to exp80. Please do the following and send the output here

exp help=y
or in your case exp80 help=y

and send the output please
Also do ls -l $ORACLE_HOME\bin and send the output as well

 

[jonybd]

Command Ok: exp80 help=y
Command Not Found: exp help=y

when doing this ->
D:\>exp80 help=y
where everything writen as exp and imp
there is no exp80 or imp80 on help=y

*why that happen ? Any Idea?
*How could i let my default $oracle_home\bin
exp80 and imp80 to exp/imp without renameing it, next time when i will install oracle 8 enterprise edition.

*Or my product is by default installing exp as exp80 and imp s imp80!

 

[sybaseguru]

On Unix you can create a soft link like below in $ORACLE_HOME/bin directory

ln -s exp80 exp
ln -s imp80 imp

Try this and you can use exp and imp in your program

 

[Turkbear]

Hi,
Oracle had a habit of naming the executables differently
when releasing some versions:
Version 8 has exp80,imp80 etc ( as well as a net80 subdirectory instead of Network ( actually some have both)..

You can just rename them in Windows, Oracle won't care..
( actually copy them to a safe area first, then rename the originals)

 

[jonybd]

Ok thanks TrukBear,sybaseguru (Instructor)

i just wanted to know as trukbear told:

::when releasing some versions:
Version 8 has exp80,imp80 etc ( as well as a net80 subdirectory instead of Network ( actually some have both)..