oracle导入导出及修改密码

oracle 导出语句

1 导出用户amardata_test的用户

exp amardata_test file=/mysqldata/20150210amardata_test.dmp log=/mysqldata/20150210amardata_test.log

2 导出某个表

将数据库中的表table1 、table2导出
  exp 用户/密码@TEST file=d:\daochu.dmp tables=(table1,table2);

导入语句

imp amardata_test/amardata_test@orcl file=/home/oracle/in/20150210amardata_test.dmp full=y ignore=y;

修改用户密码

SQL> conn /as sysdba
Connected.

//查看用户
SQL> select username,password from dba_users;

//修改用户口令 格式 alter user 用户名 identified by 新密码;

SQL> alter user system identified by manager;

User altered.

或者

alter user system identified by "amar!32";