oracle导出:exp PECARD_HN/PECARD_HN@192.168.141.40:1521/orcl file=E:\work\dmp\PECARD_HN.dmp
oracle导入:imp PECARD_HN/PECARD_HN@127.0.0.1:1521/orcl file=E:\work\dmp\PECARD_HN.dmp full=y
mysql导出:mysqldump -h 192.168.18.232 -u PECARD -p prvecard > E:\work\dmp\PECARD.sql
mysql导入:mysql -h 127.0.0.1 -u PECARD -p prvecard < E:\work\dmp\PECARD.sql
oracle创建表空间:create tablespace szxy_new_tablespace datafile 'D:\soft\oracle\product\10.2.0\oradata\szxy_new\szxy_new.dbf' size 500M;
oracle创建用户名:create user szxy_new identified by szxy_new default tablespace szxy_new_tablespace;
oracle授权给用户:
grant connect,resource to szxy_new ; grant dba to szxy_new ;