Question

怎么给oracle数据库，创建表空间和用户

Answer 1

SQL> Create User usernameIdentified by passwordDefault Tablespace tablespaceTemporary Tablespace tablespaceProfile profileQuota integer/unlimited on tablespace;例:SQL> Create user acc01identified by acc01 // 如果密码是数字，请用双引号括起来default tablespace accounttemporary tablespace tempprofile defaultquota 50m on account;SQL> grant connect, resource to acc01;[*] 查询用户缺省表空间、临时表空间SQL> select username, default_tablespace, temporary_tablespace from dba_users;[*] 查询系统资源文件名：SQL> select * from dba_profiles;资源文件类似表，一旦创建就会保存在数据库中。SQL> select username, profile, default_tablespace, temporary_tablespace from dba_users;SQL> create profile common limitfailed_login_attempts 5idle_time 5;SQL> Alter user acc01 profile common;