oracle常用语句开发记要

1.在sqlplus 中以sysdba用户登陆oracle

sqlplus "/as sysdba"

2.创建表空间、创建用户和授权

create tablespace data_xxx logging  datafile 'xxx\data_xxx.dbf' size 50m autoextend on next 50m maxsize 4096m extent management local; 

create temporary tablespace temp_xxx  tempfile 'xxx\temp_xxx .dbf' size 512m autoextend on next 36m maxsize 1024m extent management local;

create user xxx identified by xxx default tablespace data_xxx temporary tablespace temp_xxx; 

grant connect,resource,dba to xxx;

3.导入和导出oracle dmp数据文件

导入：imp user_name/user_pass@orcl_xxx file='xxx\data_xxx.dmp' full=y;

导出：exp user_name/user_pass@orcl_xxx file='xxx\data_xxx.dmp'; --full=y

4.生成UUID

sys_guid()，测试：select sys_guid() from dual;