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.

Comments

Post a Comment

Popular posts from this blog

Morning Quotes

-
Image
Source: www.brainyquote.com   I may be drunk, Miss, but in the morning I will be sober and you will still be ugly. Winston Churchill   Prayer is the key of the morning and the bolt of the evening. Mohandas Gandhi   I look upon death to be as necessary to our constitution as sleep. We shall rise refreshed in the morning. Benjamin Franklin  
Read more

QCalendarWidget CSS Stylesheeting

-
Recently I had to implement a calendar for a TouchScreen application. I resorted to css to modify the calendar widget's appearance so that it would be more accessible. Following is the code that enabled me to get a proper calendar. calendar->setStyleSheet("QMenu { font-size:20px; width: 300px; left: 20px; }"     "QToolButton {icon-size: 48px, 48px; font: 20px; height: 70px; width: 100px; }"     "QAbstractItemView {selection-background-color: rgb(255, 174, 0);}"     "QToolButton::menu-indicator{ width: 50px;}"     "QToolButton::menu-indicator:pressed,"     "QToolButton::menu-indicator:open{ top:10px; left: 10px;}"     "QTableView { font: 30px; }"     "QSpinBox { width: 100px; font: 20px;}"     "QSpinBox::up-button { width:40px;}"     "QSpinBox::down-button { width:40px;}");
Read more