Oracle数据库使用经验总结

数据库创建用户：
CREATE USER test03 IDENTIFIED BY a11111;
alter user test03 account unlock;
grant create session to test03;
grant dba to test03;
cmdk控制台导出用户下所有表信息：
exp username/password@SID file=C:\\Users\\Administrator\\Desktop\\test.dmp;
imp username/password@SID file=C:\\Users\\Administrator\\Desktop\\test.dmp ignore=y full=y;