sharifhere

 Profile Answers by sharifhere Questions by sharifhere

• Dec 7th, 2006

 

Could not able to understand clearly.. can u bit clear about "IMPORT and EXPORT of DATA"

Mehraban

• Mar 19th, 2007

 

Here's a sample shell script

sqlplus -s uname/passwd
<< EOF > data.log
select * from employees;
exit
EOF>

Guest

• Mar 25th, 2007

 

#!/bin/sh
#set the environment
export ORACLE_SID=
export ORACLE_HOME=
export PATH=$ORACLE_HOME/bin:$HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

Use the export syntax here

#Unset all the environment variables
unset ORACLE_SID
unset ORACLE_HOME
unset PATH
unset LD_LIBRARY_PATH

#Set the environmet variables for the database int which the data should be imported
export ORACLE_SID
export ORACLE_HOME
export PATH
export LD_LIBRARY_PATH

use the IMPORT syntax here

exit

<error condtion>

anuraggupta81

 Profile Answers by anuraggupta81 

• Sep 18th, 2007

 

you can use the following command to take an export dump from the shell script.

exp [DBA user/DBA Password]  FILE= [FIle NAme] TABLES={All the table names]  ROWS=y log=indigo2.log


This will create the .dmp file in the current folder

anuraggupta81

 Profile Answers by anuraggupta81 

• Sep 18th, 2007

 

Following command will be used for import from shell script

imp [DBA User/DBA Password] FILE= [File Name] FROMUSER=[User from which the dump is taken] TOUSER=i[user to which the dump will be imported]  TABLES= [table Name] log=[Log file name] ignore=y commit=Y

exp [User from whcih dump will be taken/ Password ] TABLES=[table name] FILE=[File Name] ROWS=y log=[Log file name]

Markerhell

 Profile Answers by Markerhell 

• Aug 26th, 2009

 

To import the data:
mysqldump -u username -p databasename >> databasenamedump.sql

To Export the data:
mysql -u username -p newdatabasename < databasenamedump.sql