管理
-
编辑 删除
ORACLE用户管理命令
创建用户:CREATE USER master IDENTIFIED BY master DEFAULT TABLESPACE master_space //可选TEMPORARY TABLESPACE master_tempsPROFILE master_profile &n...
-
编辑 删除
ORACLE表空间传输
1.查询编码SQL>SELECT d.PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;2.字符集检查SQL>select * from nls_database_parameters where parameter='NLS_CHARACTERSET';...
-
编辑 删除
ORACLE数据操作命令
1.表操作创建表 CREATE TABLE test1 (column_name datetype,co_n dp); [主键 CONSTRAINT id_pk PRIMARY KEY(id) [外键 col2 data_type REFERENCES table1(col1) [唯一约束 CONSTRAINT id_uk ...
