Oracle指令

select * from dba_temp_files; 查看临时表空间

select * from dba_directories; 查看逻辑目录

select * from dba_data_files; 查看表空间

select tabelspace_name ,file_name from dba_data_files; 查看表空间名称、路径

select username from dba_users; 查看用户

create user test identified by test default tablespace test ; 创建用户赋予表空间

create directory dump as '/home/test' ; 创建逻辑目录

grant read ,write on directory test to test;授予用户逻辑目录的读写权限

show user;查看当前用户 sqlplus -v 数据库版本

select instance_name from v$instance;查看数据库实例