The startup database command is divided into three stages:
startupnomount
alter database mount
alter database open
This user's permissions to read other user objects:
select * from user_tab_privs;
System permissions possessed by this user:
select * from user_sys_privs;
-------------------------------------------------- -------
Data dictionary views in ORACLE are divided into three categories, distinguished by prefixes: USER, ALL and DBA. Many data dictionary views contain similar information.
USER_*: Information about objects owned by the user, that is, object information created by the user himself
ALL_*: Information about objects that the user can access, that is, information about objects created by the user himself plus information about objects created by other users that the user has access to
DBA_*: Information about objects in the entire database
----------------------------------------
Oracle 10i
ALTER DATABASE DEFAULT TABLESPACE Modifies the default tablespace of the database
----------------------------------
set echo off;
The path to the script file generated by spool
select 'grant select,insert,delete,update on '|| table_name||' to username;' from user_tables;
spool off;
select 'revoke select,insert,update,delete on '||table_name||' from username;' from user_tables;
revoke select,insert,delete,update any table from username with grant option;
---------------
grant select,insert,delete,insert,update any table to username with grant option;
Modify the tablespace to which the table belongs
alter table table name move tablespace table space name
Note: After this operation, be sure to rebuild the index on the table, alter index index-name rebuild
-------------------
Create tablespace statement:
create tablespace tableName datafile 'e:oracle/dbName.dbf' size 1024M autoextend on next 100M maxsize unlimited;
This article comes from the CSDN blog. Please indicate the source when reprinting: http://blog.csdn.net/mzwang123/archive/2009/12/22/5053452.aspx
-