Logical Export Data

Exporting table from scott user and Table is “Emp”
oracle@localhost]$pwd
/home 
— crate a directory named export into the /home directory
Oracle@localhost]$mkdir /home/export
— give the permission of oracle and group is oinstall with change mode all.
oracle@localhost]$chown -R oracle:oinstall /home/*
oracle@localhost]$chmod 777 /home/*
oracle@localhost]$ exp USERID=scott/tiger FILE=scott_exp.dmp LOG=scott_log.log FULL=y TABLES=emp BUFFER=4096
 it has been on prompt, if you want to write it into the shell script file then you made a script file named with “exp_table.sh”.

Here is step to create a file into the export/script directory and made a file “exp_table.sh” here under.

oracle@localhost]$pwd
/home
oracle@localhost]cd export
oracle@export]$ mkdir script
oracle@export]$ cd script
oralce@script]$ pwd
/home/export/scirpt
oracle@script]vi exp_table.sh
exp USERID=scott/tiger
FILE=exp_table.dmp
FULL=y
LOG=exp_table_log.log
TABLES=emp
IGNORE=y
BUFFER=y
GRANT=y
CONSTRAINTS=y
:wq [for saving the file of vi editor press esc then :wq] 
oralce@script]sh exp_table.sh &


thanking you

Mohammad Shahnawaz
Oracle Apps DBA
Kuwait