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

Create tablespace user authorization

Create tablespace liuzhen_tablespace datafile'D:\ liuzhen_oracle_data\ liuzhen_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local

Create user liuzhen identified by 123456 default tablespace liuzhen_tablespace

Grant connect,resource,dba to liuzhen

Delete the tablespace while deleting the data file:

Drop tablespace liuzhen_tablespace including contents and datafiles

Oracle specifies the tablespace for the user and modifies the user's tablespace syntax

ALTER USER liuzhen DEFAULT TABLESPACE liuzhen_tablespace

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.