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.
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.
Comments
Post a Comment