oracle导出mysql导入,oracle与mysql导入导出

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 ;