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.

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