Oracle Creates table space, user, and permission configurations, and oracle creates
Different from mysql and sqlserver databases, an oracle database can define multiple tablespaces in the same database. Different tablespaces are independent of each other. each user has a default tablespace, therefore, data tables operated by different users can be different. Of course, you can set the tablespace when defining the tablespace.
Create a tablespace:
Create tablespace (your tablespace name is pfm) datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ pfm. dbf 'size 100 Mautoextend on next 32 M maxsize 200 M extent management local;
Create temporary tablespace:
Create temporary tablespace (your tablespace name is pfm) tempfile 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ pfm. dbf 'size 100 Mautoextend on next 32 M maxsize 200 M extent management local;
Create a new user and define the default tablespace:
Create user (the user name you want to define) identified by (your password) default tablespace (the tablespace you want to define) temporary tablespace (your temporary tablespace );
Configure user permissions:
Grant connect, resource, dba to (User Name );
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.