✍ Kashif M
Trends

Thursday, 25 July 2013


Import command in oracle


By on July 25, 2013



C:\>imp <username>/<password> file=<dumpname.dmp> log=<logfilename.log> full=y

C:\>imp kk/kk file=kk.dmp log=kkimp.log full=y

• C:\>imp <username>/<password> file=<dumpname.dmp> log=<logfilename.log> fromuser=<fromusername> touser=<tousername>

• Before import we need to check the tablespace free space.

SYSTEM -200M

INDX -100M

DEFAULT TABLESPACE (ORION) -

C:\>imp kk/kk file=kk.dmp log=kkimp.log fromuser=surya touser=kk
Imp……
Imp…….

Import completed successfully with warnings.

After Import Connect to the Respective DB user

C:\>sqlplus

Enter username: kk/kk

SQL>@c:\compile – it will compile all the Invalid objects run the compile script atlease 4 times.

Kashif
mkashu: Import command in oracle
Review : Kashif | Kashif
Update: July 25, 2013 | Rating: 4.5

Comment for "Import command in oracle"

0 comments

Post a Comment

Blog Archive