I. Import and export the remote Oracle database

I. Import and export the remote Oracle database
An example of its syntax is as follows:
imp/exp [username[/password[@service] ], where service is the name of the services instance, about how to create
Service instance name or database SID is logged in http://blog.sina.com.cn/s/blog_7ffb8dd501013e5v.html

Or: Imp/exp [username[/password[@hostIp: 1521/dbsid]] Dbsid is a database sid
such as: Exp Admin/[email PROTECTED]/ORCL (there is no write port number, because the default is 1521)

Above , import the remote database (import the database into the remote host: The service already contains the remote host information), where the figure is the key step, other direct carriage return. 2 is the location of the database, in fact, the third step can also directly enter (because the entire export file may contain more than one user's database information), and then fill in an export file included in the user can!!!



is to export the remote database, the figure is the key step, the other default carriage return

Second, import, export the local Oracle database
Syntax Examples:
Imp/exp
Enter the above command directly, as prompted, similar to the remote import export

One, import, export remote Oracle database