Create a user
create user [username] identified by [pwd]
Authorize the user
grant connect, resource, dba to [username]
Import the database
在cmd环境下,imp userid=[user]/[pwd] full=y file=[filename].dmp
Export database or tables
exp system/manager@TEST file=d:[filename].dmp full=y
exp aichannel/aichannel@TESTDB2 file= d:[filename].dmp tables=([tabel name])
reference