Import/Export a database into Oracle

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

http://www.xland.com.cn/article/74/77/0804/28794.htm