Create / Alter Oracle TableSpace / Temporary TableSpace, User...
--Create TableSpace--<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />create tablespace Live_DB
logging
datafile C:\oracle\oradata\lilo\Live_DB01.dbf;
size 2m
autoextend on
next 2m maxsize 204m
extent management local;
--Create Temporary TableSpace--
Create Temporary tablespace Live_Temp_DB
tempfile C:\oracle\oradata\lilo\Live_Temp_DB01.dbf;
size 2m
autoextend on
next 2m maxsize 204m
extent management local;
--Create User and Assign TableSpace / Temporary Tablespace to User--
create user Lilo_X3 identified by password
default tablespace live_db
temporary tablespace live_temp_db;
--Alter User Tabblespace--
alter user lilo_x1
default tablespace live_db
temporary tablespace live_temp_db;
--Grant Permission Connect Oracle and Create Oracle Object to User--
grant connect,resource to lilo_X1;
页:
[1]