Data import and export of Oracle database

--Backing up the database
--Database System user account
System/adminuser

--View the users of the Oracle database
SELECT * from All_users;
--View the version number of the Oracle database
SELECT * from V$version;

Backing up data

Sqlplus Adminuser/[email protected]/jnbase--you can see the version number of Oracle version=10.2.0.1.0
Exp Adminuser/[email protected]:1521/jnbase file=f:\nihao.dmp owner=adminuser
C:\users\happiness>exp adminuser/[email PROTECTED]:1521/ORCL file=f:\adminuser.dmp full=y
C:\users\administrator>exp adminuser/[email PROTECTED]:1521/ORCL file=d:\adminuser.dmp full=y

--Remote Export database ******
Exp Adminuser/[email PROTECTED]:1521/ORCL file=e:\hello\newdatabaseback\adminuser.dmp owner=adminuser

--Local export database ******
Exp Adminuser/[email PROTECTED]:1521/ORCL file=e:\hello\newdatabaseback\adminuser.dmp owner=adminuser

--Local Import database ******
Imp user_test/[email protected]:1521/orcl file= ' E:\hello\newDataBaseBack\test1122.dmp ' full=y ignore=y

Data import and export of Oracle database