Monday, July 16, 2012

easing up on oracle import

Open import_database.dat and change the path to dmp file. Save it and run it!

C:\import_database.bat

sqlplus sys/sys as sysdba @C:\SqlRefresh.sql
imp m1/m1@m1 fromuser=m1 touser=m1 ignore=y file=c:\cat.DMP

C:\SqlRefresh.sql

connect sys/sys as sysdba;
drop user m1 cascade;
create user m1 identified by m1;
grant dba to m1;
exit;

Working:
import_database.bat logs user in as sys and deletes user m1 so that his database is deleted along with him. Then it creates the same user and grants him dba privileges. All this is done in file SqlRefresh.sql.

Next we import the new dump with the help of imp command.

No comments:

Post a Comment