两讫是什么意思,临沭信息港,www.2008tv
sys > system > sysman > scott
scott 默认密码 tiger
system/密码 或 connect sys/密码 as sysdba
查看当前用户:show user
查看用户 数据字典:desc dba_users
查看数据字典中 用户信息:select username from dba_users;
启用用户:alter user username account unlock;
descdba_tablespaces
select tablespace_name from dba_tablespaces|user_tablespaces;
select default_tablespace,temporary_tablespace from dba_users where username='SYSTEM';
注:查找时,字段值要大写!
alter user username default|temporary tablespace tablespace_name;
例:alter user system default tablespace system;
CREATE [TEMPORARY] TABLESPACE tablespace_name DATAFILE|TEMPFILE 'xxx.dbf' SIZE xx;
例:CREATE TABLESPACE test1_tablespace DATAFILE 'test1file.dbf' SIZE 10m;
例:CREATE TEMPORARY TABLESPACE temptest1_tablespaceTEMPFILE'tempfile1.dbf' SIZE 10m;
desc dba_data_files
select file_name from dba_data_files where tablespace_name='TEST1_TABLESPACE';
注:查找时,字段值要大写!
descdba_tablespaces
select status from dba_tablespaces where tablespace_name='TEST1_TABLESPACE';
注:查找时,字段值要大写!
修改表空间
是否脱机:ALTER TABLESPACE tablespace_name ONLINE|OFFLINE;
例:ALTER TABLESPACE test1_tablespace OFFLINE;
读写状态:ALTER TABLESPACE tablespace_name READ ONLY|READ WRITE;
例:ALTER TABLESPACE test1_tablespaceREAD WRITE; (注:等于ONLINE)
增加表空间的数据文件
ALTER TABLESPACE tablespace_name ADD DATAFILE 'xx.dbf' SIZE xx;
例:ALTER TABLESPACE test1_tablespaceADD DATAFILE 'test2_file.dbf' SIZE 10m;
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Oracle字符串函数length、upper、lower、initcap、 concat、instr、replace
网友评论