Oracle creates table spaces

• 1. Open Sqlplus Login User

> System as Sysdba

>****

• 2, create a temporary table space

Create Temporary  'D:\else\oracle\tablespace\vtm\vtmtemp.dbf' on  Next  50m maxsize 20480mextent Management local

• 3, create a data table space

Create tablespace vtmdatalogging   ' D:\else\oracle\tablespace\vtm\vtmdata.dbf ' size 50m    on  Next 50m maxsize 20480m  extent management local;

4, assigning table spaces to users

-- Create a user and assign temporary tablespace and data table space Create User  by 1234 default tablespace vtmdata Temporary tablespace vtm_temp; -- Change the user temp table space and the data table space Alter User  default  tablespace vtmdatatemporary tablespace vtm_temp

Most of the blog from the network, if there is a copyright issue please contact me to delete or modify, blog content mainly for their own study and note use and hope to provide some help to the needs of friends, do not like to spray, you are welcome to point out the mistakes, learning, progress.

Contact e-mail:[email protected]

qq:1129368407

Oracle creates table spaces