Shulou(Shulou.com)06/01 Report--

1. Connect to the database

# su-oracle$ conn / as sysdba

2. Create a tablespace

SQL > create tablespace doiido datafile'/ doiido/oracle/oradata/doiido.dbf' size 1024M autoextend on next 1024M maxsize 1024M extent management local

3. Create a user (user name is doiidoname, password is doiidopasswd, default tablespace is doiido)

SQL > create user doiidoname identified by doiidopasswd default tablespace doiido

4. Authorization

SQL > grant connect, resource to doiido

5. No tablespace quota control for users

SQL > grant unlimited tablespace to doiido

6. Switch user login

SQL > conn doiido/doiido

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.