1、启动数据库服务命令:net start OracleServiceXE
停止数据库服务命令:net stop OracleServiceXE
2、更改数据库端口:
begin
dbms_xdb.sethttpport('8888');
dbms_xdb.setftpport('0');
end;
/
3、导入导出命令:
导入:
imp ROBOFUND/ROBOFUND@XE file=d:/robofund20181108.dmp full = y
imp JH_FUND_TEST/JH_FUND_TEST@190.190.11.18:1521/orcl file=g:/fund_20151230.dmp fromuser=JH_FUND_TEST
导出:
exp YTFUNDDEV/YTFUNDDEV@XE file=D:/YTFUNDDEV_201806221720_kongku.dmp
exp FUNDVIEW/FUNDVIEW@190.190.11.18:1521/fund file=d:/FUNDVIEW.dmp
4、用户授权:
grant dba to 用户名
5、连接数据库:
conn 用户名/密码 as sysdba
6、清库:
drop tablespace USERS INCLUDING CONTENTS CASCADE constraints;
7、创建表空间:
CREATE TABLESPACE USERS LOGGING DATAFILE 'D:\oraclexe\app\oracle\oradata\XE\USERS.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 11G EXTENT MANAGEMENT LOCAL;
8、创建用户:
CREATE USER FUND IDENTIFIED BY FUND DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
9、删除用户:
drop user FUND cascade;
oracle相关命令
最新推荐文章于 2023-10-19 10:04:07 发布