时间：2021-07-01 10:21:17 帮助过：2人阅读
//登录命令 sqlplus sys/oracle as sysdba; //sys/oracle 为 用户名/密码 //删除表空间 MOF drop tablespace MOF including contents and datafiles cascade constraints; //删除用户 yaojian drop user yaojian cascade; //创造表空间MOF 路径 create tablespace MOF logging datafile ‘D:\oracle\product\10.2.0\oradata\orcl\MOF.dbf‘ size 1024m autoextend on next 1024m maxsize 1024m extent management local; //给表空间 赋用户 create user yaojian identified by yaojian default tablespace MOF; grant dba to yaojian; //导入数据 给某个用户 imp yaojian/yaojian@localhost/orcl file="D:\xcframework20150713.dmp" full=y;
ORACLE 数据库 操作命令
标签：