about uscontact

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

Category:
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 *

ZEMNA.NET

Professional software development agency estalished in Indonesia. We offers website setup, web application development, fulfillment service, and etc.
Follow us
Follow us to get latest news and tutorials.
2022 - Copyright, All Rights Reserved, Made by ZEMNA.NET with ❤️
magnifiercrossmenu