崆峒山人

1. 查看当前用户select user from dual;select * from user_users;2. 查看当前用户拥有的角色和权限：select * from user_role_privs;select * from session_privs;3. 查看表注释select tab.* from user_tab_comments tab where

1. 创建临时表空间 CREATE TEMPORARY TABLESPACE test_temp TEMPFILE 'G:\app\Administrator\oradata\orcl1\test_temp.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;2. 创建表空间

查看用户名-默认表空间-临时表空间select username, default_tablespace, temporary_tablespace from dba_users;查看表空间信息select t.* from dba_tablespaces t where t.TABLESPACE_NAME ='USERS'

oracle安装问题：1.undefined reference to `nnfyboot'    export ORACLE_HOME=/your/oracle/home    cd $ORACLE_HOME/lib    ln -s libclient10.a libagtsh.a    cd $ORACLE_HOME    LD_LIBRARY_PATH=$ORACL