Date: Fri, 29 Mar 2024 16:51:14 +0900 (KST) Message-ID: <758486653.4475.1711698674801@[106.255.156.234]> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_4474_1638509189.1711698674793" ------=_Part_4474_1638509189.1711698674793 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
=EC=9D=B4 =ED=8E=98=EC=9D=B4=EC=A7=80=EB=8A=94 JIRA= Oracle =EC=84=A4=EC=A0=95=EC=97=90 =EB=8C=80=ED=95=9C =EA=B0=80=EC=9D=B4= =EB=93=9C=EB=A5=BC =EC=A0=9C=EA=B3=B5=ED=95=9C=EB=8B=A4.
Oracle =EC=A0=91=EC=86=8D=EC=9D=84 =ED=95=9C=EB=8B=A4.(sys =EB=98=90=EB= =8A=94 sysdba)
=EA=B8=B0=EC=A1=B4 Instance=EC=97=90=EC=84=9C =EC=8B=A0=EA=B7=9C tablesp= ace =EC=9D=98 user =EC=83=9D=EC=84=B1=ED=95=9C=EB=8B=A4.
=ED=85=8C=EC=9D=B4=EB=B8=94 =EC=8A=A4=ED=8E=98=EC=9D=B4=EC=8A=A4 =EC=83= =9D=EC=84=B1 =EC=BF=BC=EB=A6=AC
create tablespac= e conf_tablespace datafile 'c:\xxx\xxx.dbf' size 1G autoextend on extent management local autoallocate;
linux=EC=9D=98 =EA=B2=BD=EC=9A=B0 datafile(xxx.dbf)=EC=9D=98 default loc= ation=EC=9D=B4 =EC=95=8C=EA=B3=A0 =EC=8B=B6=EC=9C=BC=EB=A9=B4
SQL> Select = * from dba_data_files ;
...
FILE_NAME
--------------------------------------------------------------------------=
------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------<=
br>
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------=
ONLINE_ LOST_WR
------- -------
/home/oracle/db/or=
adata/orcl/system01.dbf
1 SYSTEM 838860800 102400 AVAILABLE
1 YES 3.4360E+10 4194302 1280 837812224 102272
SYSTEM OFF
...
=EC=8B=A0=EA=B7=9C =EC=9C=A0=EC=A0=80 =EC=83=9D=EC=84=B1=EC=8B=9C =EC=8B= =A0=EA=B7=9C=EB=A1=9C =EB=A7=8C=EB=93=A0 =ED=85=8C=EC=9D=B4=EB=B8=94=EC=8A= =A4=ED=8E=98=EC=9D=B4=EC=8A=A4=EB=A1=9C =EC=A7=80=EC=A0=95=ED=95=9C=EB=8B= =A4.
create user [use= rID] identified by userpassword default tablespace conf_tablespace quota un= limited on conf_tablespace;
=EC=9C=84=EC=9D=98 =EB=AA=85=EB=A0=B9=EC=96=B4=EB=A1=9C user=EB=A5=BC = =EB=A7=8C=EB=93=A0 =ED=9B=84 =EB=8B=A4=EC=9D=8C =EB=AA=85=EB=A0=B9=EC=96=B4= =EB=A1=9C quota=EA=B0=80 =EC=9E=98=EB=A7=8C=EB=93=A4=EC=96=B4=EC=A1=8C=EB= =8A=94=EC=A7=80 =ED=99=95=EC=9D=B8=ED=95=B4=EB=B3=B8=EB=8B=A4.
select tablespa= ce_name, username, bytes, max_bytes from dba_ts_quotas where tablespace_name =3D 'conf_tablespace' and username =3D [userID]; =EC=9C=84=EC=9D=98 =EA=B2=B0=EA=B3=BC=EA=B0=92=EC=9D=B4 =EC=95=84=EB=AC=B4= =EA=B2=83=EB=8F=84 =EB=82=98=EC=98=A4=EC=A7=80 =EC=95=8A=EC=9C=BC=EB=A9=B4(= no rows selected) =EB=AC=B8=EC=A0=9C=EA=B0=80 =EC=9E=88=EB=8A=94 =EA=B2=83= =EC=9D=B4=EA=B3=A0=20 =EC=95=84=EB=9E=98=EC=99=80 =EA=B0=99=EC=9D=B4 =EB=82=98=EC=98=A4=EB=A9=B4 = quota=EA=B0=80 =EC=A3=BC=EC=96=B4=EC=A7=84 =EA=B2=83, =EC=A6=89 =ED=95=B4= =EB=8B=B9 =EC=9C=A0=EC=A0=80=EB=A1=9C insert table =EA=B0=99=EC=9D=80 =EA= =B2=83=EC=9D=B4 unlimited=ED=95=98=EA=B2=8C =EC=82=AC=EC=9A=A9=ED=95=A0 =EC= =88=98 =EC=9E=88=EA=B2=8C =EC=9E=98 =EC=84=A4=EC=A0=95=ED=95=B4=EC=A4=80 = =EA=B2=83=EC=9D=B4=EB=8B=A4.=20 TABLE USERNA BYTES MAX_BYTES ----- ------ ---------- ---------- USERS FOOBAR 0 10485760 1 row selected.
4. =EC=82=AC=EC=9A=A9=EC=9E=90 =EA=B6=8C=ED=95=9C =EB=B6=80=EC=97=AC
=EC=82=AC=EC=9A=A9=EC=9E=90=EC=97=90 =EB=8C=80=ED=95=9C =EA=B6=8C=ED=95=
=9C=EC=9D=84 =EB=B6=80=EC=97=AC=ED=95=9C=EB=8B=A4.
grant connect to= user_name; grant create table to user_name; grant create sequence to user_name; grant resource to user_name; grant create trigger to user_name;