| TABLE |

 CREATE USER 
session
C##
๋น„๋ฐ€๋ฒˆํ˜ธ โ€œโ€

 

| TABLESPACE |

ํ…Œ์ด๋ธ” ์ŠคํŽ˜์ด์Šค ์ƒ์„ฑํ•˜๊ธฐ  (ํ…Œ์ด๋ธ” ์ŠคํŽ˜์ด์Šค์™€ ๋ฐ์ดํ„ฐํŒŒ์ผ์˜ ์ด๋ฆ„์ด ๊ฐ™์„ ํ•„์š”๋Š” ์—†์Œ)

CREATE TABLESPACE example
	DATAFILE 'C:\ORACLE\DATA\example.DBF' 
    SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED 
    DEFAULT STORAGE(INITIAL 128K NEXT 64K PCTINCREASE 10);

 

๋ฐ˜์‘ํ˜•
์ €์ž‘์žํ‘œ์‹œ (์ƒˆ์ฐฝ์—ด๋ฆผ)

'DBMS > Oracle' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

[Oracle] ORA-01033 ์—๋Ÿฌ ๋ฐœ์ƒ ์ž„์˜๋กœ datafile ์‚ญ์ œํ•ด์„œ ๋ฐœ์ƒ  (0) 2023.06.10

https://adbancedteam.tistory.com/148

 

[Admin] ORA-01157, ORA-01110 ์žฅ์•  ํ•ด๊ฒฐ ๋ฐฉ์•ˆ

1. ๋ฌธ์ œ ๋ฐœ์ƒ - DB ์˜คํ”ˆ ์‹œ UNDO ๋ฐ์ดํ„ฐ ํŒŒ์ผ ์—๋Ÿฌ ๋ฐœ์ƒ SQL> startup ORACLE instance started. Total System Global Area 422670336 bytes Fixed Size 1344616 bytes Variable Size 314575768 bytes Database Buffers 100663296 bytes Redo Buffers 6086656

adbancedteam.tistory.com

 

๋ฐ˜์‘ํ˜•
์ €์ž‘์žํ‘œ์‹œ (์ƒˆ์ฐฝ์—ด๋ฆผ)

'DBMS > Oracle' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

Oracle sql ๋ชจ์Œ / ์ •๋ฆฌ (TABLE, TABLESPACE, USER)  (0) 2023.06.20

+ Recent posts

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”