oracle创建

@echo off
echo? Oracle 数据库，请稍等......
exp gz/[email?protected]/ORCL file=D:/backup/bak_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=D:/backup/bak_%date:~0,2%.log
echo 任务完成！

?

CREATE TEMPORARY TABLESPACE gz_temp
TEMPFILE ‘E:appAdministratororadataorclgz_temp.dbf‘
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

?

创建表空间
create tablespace gz
logging
datafile ‘E:appAdministratororadataorclgz.dbf‘
size 7167M
autoextend on
next 3072M maxsize 32767M
autoallocate
extent management local
segment space management auto;

create user gz identified by "123"
default tablespace gz
temporary tablespace tongtai_temp profile DEFAULT;

grant connect,resource,dba to user;

imp gz/[email?protected] fromuser=gz touser=gz file=D:20190311.dmp ignore = y

imp yjt/[email?protected]:1521/orcl file=d:20190311 full=y

?

oracle数据库cmd导出指令：
exp username/[email?protected]/orcl file=f:filename.dmp

oracle数据库cmd导入指令：

imp username/[email?protected]/orcl file=f:filename.dmp full=y

//查询字符集SQL
select userenv(‘language‘) from dual;

https://zhidao.baidu.com/question/1989688239134896747.html修改字符编码查询字符编码select userenv(‘language‘) from dual;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!