1.新建数据库以及服务
Oracle-OraHome9i-Configuration and Migration Tools-Database Configuration Assistant
根据向导新建完之后,修改Oracle数据库的端口号:(端口号默认为8080以免冲突)
Oracle-OraHome9i-Enterprise Manager Console-进入控制台-选中数据库-XML数据库-配置-修改http-port
2.新建表空间
CREATE TABLESPACE "LPSSX"
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\ORADB\LPS1X.ora' SIZE 20M,'D:\ORACLE\ORADATA\ORADB\LPS2X.ora' SIZE 20M REUSE
AUTOEXTEND
ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
3.新建用户并授权
CREATE USER "LPSSX" PROFILE "DEFAULT"
IDENTIFIED BY "lpssx" DEFAULT TABLESPACE "LPSSX"
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "LPSSX";
GRANT "RESOURCES" TO "LPSSX";
GRANT "DBA" TO "LPSSX";
GRANT UNLIMITED TABLESPACE TO LPSSX;
GRANT CREATE ANY DIRECTORY TO LPSSX;
4.导入导出数据库命令
如果没有设置Oracle环境变量的话,在Oracle-bin下引用imp与exp命令:
导入:imp 当前用户名/密码@数据库 full=y file=D:\123.dmp(导出文件路径) fromuser=创建备份的用户 touser=恢复到的用户
导出:exp 当前用户名/密码@数据库 full=y file=D:\123.dmp(导入文件路径) fromuser=创建备份的用户 touser=恢复到的用户