oracle 如何创建新用户
打开 PL/SQL developer ,在SQL命令窗口输入如下内容
创建用户:
create user 用户名 identified by 密码;
授权:
grant connect,resource,dba to 用户名;
PLSQL 查询数据库版本:
select * from v$version;
查看数据库字符集:
select * from nls_database_parameters where parameter=‘NLS_CHARACTERSET’;
select userenv(‘language’) from dual;
查看所有表空间及表空间大小:
select tablespace_name ,sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablespace_name;
查看所有表空间对应的数据文件:select tablespace_name,file_name from dba_data_files;
修改数据文件大小:alter database datafile ‘H:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\USERS01.DBF’ RESIZE 10240M;
查看日志大小:
SELECT SUM(BLOCKS *BLOCK_SIZE )/1024/1024 AS “Size(M)”,TRUNC(completion_time) FROM v$archived_log GROUP BY TRUNC(completion_time)