Oracle Table Space 및 사용자 계정 생성 방법

Author: zemna
Date: April 17, 2021
Share this:

1. Table Space 생성

create tablespace OPPRA datafile '/oracle/SAFEDB/oradata/Ora10g/oppra.dbf' size 500m autoextend on next 100m maxsize 700m;

2. 사용자 계정 생성

create user oppra identified by ocspgd default tablespace OPPRA

3. 사용 권한

grant connect to jiwon; grant resource to jiwon;

Share this:

Leave a Reply

Your email address will not be published. Required fields are marked *

Let's connect and create
something awesome together!
2023 - Copyright, All Rights Reserved, Made by ZEMNA.NET with ❤️
crossmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram