SQL Developer create new database user and connection(创建新用户和数据库连接以及导入数据库备份文件dmp)

创建数据库连接

·       Open oracle sql developer

·        CTRL+N -> Database Connection  -> filling info as below pic shows

·        Note: Make sure SID is right, clicking Test before clicking Connect.

·        CTRL+N -> SQL File -> do as bellow to create a new database user

·        Press F5 to run the script

·         Then create a connect for SIGNALMONITOR  as following shows

Now you have created a new database user as well as a new sql connection, next step let's import a database backup file(Ex: signalmonitorDB0924.dmp)

•  window+R to open the cmd.exe,  then key in command as following shows

imp system/passwordOfsystem@orcl file=c:\signalmonitorDB0924.dmp full=y