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

1. Create a tablespace

Create tablespace tablespace name

Datafile'D:\ app\ Administrator\ oradata\ orcl\ ABC.DBF'

Size 100M autoextend on next 50M maxsize unlimited

2. Build users

Create user user name identified by password

Default tablespace tablespace name

Temporary tablespace temp (default tablespace name)

3. Give permissions to users

Grant connect,resource,dba to user name

4. Change the tablespace name

Alter tablespace tablespace name 1 rename to tablespace new name

5. Delete tablespace

Drop tablespace tablespace name including contents and datafiles

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.