{"id":2326,"date":"2018-01-26T13:36:07","date_gmt":"2018-01-26T04:36:07","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2326"},"modified":"2018-01-26T13:52:31","modified_gmt":"2018-01-26T04:52:31","slug":"oracle-12c-multitenant-%ec%95%84%ed%82%a4%ed%85%8d%ec%b3%90","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2326","title":{"rendered":"[Oracle 12c] Multitenant \uc544\ud0a4\ud14d\uccd0"},"content":{"rendered":"
\n

<\/a>Multitenant <\/span><\/span>\uc544\ud0a4\ud14d\uccd0<\/span> <\/span><\/span><\/h2>\n<\/div>\n


\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0c1\ud0dc\uc640 \ubc84\uc804 \uc815\ubcf4\ub97c \ud655\uc778\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

[oracle@New-Features-12c ~]$ <\/span>sqlplus \/ as sysdba<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 7
\n07:51:06 2015<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle.\u00a0 <\/span>All rights reserved.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

Connected to:<\/span><\/span><\/p>\n

Oracle Database 12c Enterprise Edition Release
\n12.1.0.2.0 – 64bit Production<\/span><\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP,
\nAdvanced Analytics<\/span><\/span><\/p>\n

and Real Application Testing options<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>select instance_name,status from
\nv$instance;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

INSTANCE_NAME\u00a0\u00a0\u00a0 <\/span>STATUS<\/span><\/span><\/p>\n

—————- ————<\/span><\/span><\/p>\n

CDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>OPEN<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>set lines 100<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select * from v$version;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

BANNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>CON_ID<\/span><\/span><\/p>\n

——————————————————————————–
\n———-<\/span><\/span><\/p>\n

Oracle Database 12c Enterprise Edition Release
\n12.1.0.2.0 – 64bit Production\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n

PL\/SQL Release 12.1.0.2.0 – Production\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n

CORE\u00a0\u00a0\u00a0 <\/span>12.1.0.2.0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>Production\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n

TNS for Linux: Version 12.1.0.2.0 – Production\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n

NLSRTL Version 12.1.0.2.0 – Production\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

Listener <\/span><\/span>\uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. <\/span>\uc11c\ube44\uc2a4\uac00 \uae30\ub3d9\ub418\uc5b4 \uc788\uace0 \ud574\ub2f9 \uc778\uc2a4\ud134\uc2a4\uac00 \u201cREADY\u201d <\/span>\uc778 \uac83\uc744 \ud655\uc778\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>!lsnrctl status<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on
\n12-AUG-2015 05:07:01<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

Copyright (c) 1991, 2014, Oracle.\u00a0 <\/span>All rights reserved.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

Connecting to
\n(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=New-Features-12c.compute-kroracleko58578.oraclecloud.internal)(PORT=1521)))<\/span><\/span><\/p>\n

STATUS of the LISTENER<\/span><\/span><\/p>\n

————————<\/span><\/span><\/p>\n

Alias\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>LISTENER<\/span><\/span><\/p>\n

Version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>TNSLSNR for Linux: Version 12.1.0.2.0 – Production<\/span><\/span><\/p>\n

Start Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>12-AUG-2015 00:47:44<\/span><\/span><\/p>\n

Uptime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0 days 4 hr. 19 min. 17 sec<\/span><\/span><\/p>\n

Trace Level\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>off<\/span><\/span><\/p>\n

Security\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>ON: Local OS Authentication<\/span><\/span><\/p>\n

SNMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>OFF<\/span><\/span><\/p>\n

Listener Parameter File\u00a0\u00a0 <\/span>\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/listener.ora<\/span><\/span><\/p>\n

Listener Log File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\/u01\/app\/oracle\/diag\/tnslsnr\/New-Features-12c\/listener\/alert\/log.xml<\/span><\/span><\/p>\n

Listening Endpoints Summary…<\/span><\/span><\/p>\n

\u00a0 <\/span><\/span>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=New-Features-12c.compute-kroracleko58578.oraclecloud.internal)(PORT=1521)))<\/span><\/span><\/p>\n

\u00a0 <\/span><\/span>(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))<\/span><\/span><\/p>\n

\u00a0 <\/span><\/span>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=New-Features-12c.compute-kroracleko58578.oraclecloud.internal)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/admin\/CDB1\/xdb_wallet))(Presentation=HTTP)(Session=RAW))<\/span><\/span><\/p>\n

Services Summary…<\/span><\/span><\/p>\n

Service “CDB1.kroracleko58578.oraclecloud.internal” has
\n1 instance(s).<\/span><\/span><\/p>\n

\u00a0 <\/span><\/span>Instance “CDB1”, status READY, has
\n1 handler(s) for this service…<\/span><\/span><\/p>\n

Service “CDB1XDB.kroracleko58578.oraclecloud.internal”
\nhas 1 instance(s).<\/span><\/span><\/p>\n

\u00a0 <\/span><\/span>Instance “CDB1”, status READY, has
\n1 handler(s) for this service…<\/span><\/span><\/p>\n

Service “pdb1.kroracleko58578.oraclecloud.internal” has
\n1 instance(s).<\/span><\/span><\/p>\n

\u00a0 <\/span><\/span>Instance “CDB1”, status READY, has
\n1 handler(s) for this service…<\/span><\/span><\/p>\n

The command completed successfully<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\ud604\uc7ac \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 \uc11c\ube44\uc2a4 \ubaa9\ub85d\ub3c4 \ud655\uc778\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>set lines 120<\/span><\/span><\/span><\/p>\n

SQL> <\/span>col name for a80<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select name,con_id from v$services;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>CON_ID<\/span><\/span><\/p>\n

——————————————————————————–
\n———-<\/span><\/span><\/p>\n

pdb1.kroracleko58578.oraclecloud.internal\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

CDB1XDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

CDB1.kroracleko58578.oraclecloud.internal\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

SYS$BACKGROUND\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

SYS$USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

CON_ID <\/span><\/span>\uce7c\ub7fc \uac12\uc774 \uc758\ubbf8\ud558\ub294 \ubc14\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n\n\n\n\n
\n

Value in CON_ID Column<\/span><\/span><\/p>\n<\/td>\n

\n

Description<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

0<\/span><\/span><\/p>\n<\/td>\n

\n

The data pertains to the entire CDB<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

1<\/span><\/span><\/p>\n<\/td>\n

\n

The data pertains to the root<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

2<\/span><\/span><\/p>\n<\/td>\n

\n

The data pertains to the seed<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

3-254<\/span><\/span><\/p>\n<\/td>\n

\n

The data pertains to a PDB. Each PDB has its own
\nContainer ID<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\uc0dd\uc131\ub418\uc5b4 \uc788\ub294PDB<\/span>\ubaa9\ub85d\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. SHOW <\/span>\uba85\ub839\uc73c\ub85c\ub3c4 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>set lines 120<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select con_id,name,open_mode from
\nv$pdbs;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0 <\/span><\/span>CON_ID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>OPEN_MODE<\/span><\/span><\/p>\n

———- ——————————
\n———-<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>READ ONLY<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>READ WRITE<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>show pdbs<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0 <\/span><\/span>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>OPEN
\nMODE\u00a0 <\/span>RESTRICTED<\/span><\/span><\/p>\n

———- —————————— ———-
\n———-<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>READ ONLY\u00a0 <\/span>NO<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>READ WRITE NO<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

SHOW <\/span><\/span>\uba85\ub839\uc73c\ub85c \ud604\uc7ac \uc811\uc18d\ud55c \ucee8\ud14c\uc774\ub108 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uacfcID<\/span>\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. SYS_CONTEXT <\/span>\ud568\uc218\ub85c\ub3c4 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>show con_name<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

CON_NAME<\/span><\/span><\/p>\n

——————————<\/span><\/span><\/p>\n

CDB$ROOT<\/span><\/span><\/p>\n

SQL> <\/span>show con_id<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

CON_ID<\/span><\/span><\/p>\n

——————————<\/span><\/span><\/p>\n

1<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>select sys_context(‘userenv’,’con_name’) from
\ndual;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SYS_CONTEXT(‘USERENV’,’CON_NAME’)<\/span><\/span><\/p>\n

———————————————————————————————<\/span><\/span><\/p>\n

CDB$ROOT<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>select sys_context(‘userenv’,’con_id’) from
\ndual;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SYS_CONTEXT(‘USERENV’,’CON_ID’)<\/span><\/span><\/p>\n

———————————————————————————————<\/span><\/span><\/p>\n

1<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

CDB<\/span><\/span>\uc758redo log file<\/span>\uacfccontrol file <\/span>\uad6c\uc870\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. redo log file<\/span>\uacfccontrol file\u00a0<\/span>\uc740Root <\/span>\ucee8\ud14c\uc774\ub108\ub098 \ud2b9\uc815\u00a0PDB<\/span>\uac00 \uc544\ub2cc \uc804\uccb4\u00a0CDB <\/span>\uc18c\uc18d\uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>col member for a50<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select group#,con_id,member from
\nv$logfile;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0 <\/span><\/span>GROUP#\u00a0\u00a0\u00a0\u00a0 <\/span>CON_ID MEMBER<\/span><\/span><\/p>\n

———- ———-
\n————————————————–<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0 \/u04\/app\/oracle\/redo\/redo03.log<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0 \/u04\/app\/oracle\/redo\/redo02.log<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0 \/u04\/app\/oracle\/redo\/redo01.log<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>col name for a60<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select name,con_id from v$controlfile;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>CON_ID<\/span><\/span><\/p>\n

————————————————————
\n———-<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/control01.ctl\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n

\/u03\/app\/oracle\/fast_recovery_area\/CDB1\/control02.ctl\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\"clip_image001[4]\"<\/a><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

CDB<\/span><\/span>\uc758 \ub370\uc774\ud130\ud30c\uc77c \uad6c\uc870\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. CDB_* View<\/span>\ub97c \ud1b5\ud574PDB<\/span>\ud3ec\ud568 \uc804\uccb4 \ub370\uc774\ud130\ud30c\uc77c \uc815\ubcf4\ub97c \ud655\uc778\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>col file_id for 99999<\/span><\/span><\/span><\/p>\n

SQL> <\/span>col con_id for 99999<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select file_name,tablespace_name,file_id,con_id from
\ncdb_data_files order by 4;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

FILE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>TABLESPACE FILE_ID CON_ID<\/span><\/span><\/p>\n

————————————————————
\n———- ——- ——<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/system01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/sysaux01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>SYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/undotbs01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0 <\/span>UNDOTBS1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>4\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/users01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>6\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/PDB1\/system01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>12\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/PDB1\/example01.dbf\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>EXAMPLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>15\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/PDB1\/SAMPLE_SCHEMA_users01.dbf\u00a0 <\/span>USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>14\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/PDB1\/sysaux01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>SYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>13\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

8 rows selected.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\uc774\ubc88\uc5d0\ub294DBA_*\u00a0 <\/span>View<\/span>\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ud30c\uc77c \uc815\ubcf4\ub97c \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4. Root <\/span>\ucee8\ud14c\uc774\ub108\uc758 \ub370\uc774\ud130\ud30c\uc77c \uc815\ubcf4\ub9cc \ub098\uc624\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>select file_name,tablespace_name,file_id from
\ndba_data_files;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

FILE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>TABLESPACE FILE_ID<\/span><\/span><\/p>\n

————————————————————
\n———- ——-<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/system01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/sysaux01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>SYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/undotbs01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>UNDOTBS1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>4<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/users01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>6<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

V$~ View<\/span><\/span>\uc5d0\uc11c\ub294 \ubaa8\ub4e0PDB<\/span>\ub4e4\uc758 \uc815\ubcf4\uac00 \ucd9c\ub825\ub429\ub2c8\ub2e4. <\/span>\ucee8\ud14c\uc774\ub108\ubcc4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc774\ub984\uc740 \ub3d9\uc77c\ud558\ub354\ub77c\ub3c4 \ud574\ub2f9 \ub370\uc774\ud130\ud30c\uc77c\uc758\u00a0file#\u00a0<\/span>\ub294 \ub2e4\ub978 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> <\/span>col name for a20<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select a.file#, b.name, b.ts#, b.con_id from v$datafile
\na, v$tablespace b where a.ts# = b.ts# and a.con_id = b.con_id order by
\n4,3;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>FILE#
\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>TS# CON_ID<\/span><\/span><\/p>\n

———- ——————– ———-
\n——<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>1 SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>3 SYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>4 UNDOTBS1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>2\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>6 USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>4\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>5 SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>2<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>7 SYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>2<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>16 USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>2<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>12 SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>13 SYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>14 USERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>\u00a0 <\/span>15
\nEXAMPLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>4\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

11 rows selected.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

CDB<\/span><\/span>\uc758temp file <\/span>\uad6c\uc870\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. <\/span>\ucee8\ud14c\uc774\ub108\ub9c8\ub2e4temp file<\/span>\uc744 \ubcc4\ub3c4\ub85c\ub3c4 \uac00\uc9c8 \uc218 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> <\/span>select file_name,tablespace_name,file_id from
\ncdb_temp_files;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

FILE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>TABLESPACE
\nFILE_ID<\/span><\/span><\/p>\n

————————————————————
\n———- ——-<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/temp01.dbf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>TEMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

\/u02\/app\/oracle\/oradata\/CDB1\/PDB1\/PDB1_temp012015-08-12_01-1
\nTEMP\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

5-39-AM.dbf<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

 <\/p>\n

SYSTEM <\/span><\/span>\uc720\uc800\uac00 \uc5b4\ub5bb\uac8c \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 \uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. SYSTEM <\/span>\uc720\uc800\uc640 \uac19\uc774 \ubaa8\ub4e0 \ucee8\ud14c\uc774\ub108\uc5d0 \uc874\uc7ac\ud558\ub294 \uc720\uc800\ub97cCommon User<\/span>\ub77c\uace0 \ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n

\"clip_image003[4]\"<\/a><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>col username for a30<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select username,common,con_id from cdb_users where
\nusername = ‘SYSTEM’;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>COM CON_ID<\/span><\/span><\/p>\n

—————————— — ——<\/span><\/span><\/p>\n

SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\ud604\uc7acCDB<\/span>\uc5d0 \uc0dd\uc131\ub41c \ubaa8\ub4e0Common User<\/span>\ub97c \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> set pages 100<\/span><\/span><\/p>\n

SQL> select distinct username from cdb_users where
\ncommon = ‘YES’;<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

USERNAME<\/span><\/span><\/p>\n

——————————<\/span><\/span><\/p>\n

DVF<\/span><\/span><\/p>\n

APEX_040200<\/span><\/span><\/p>\n

MDSYS<\/span><\/span><\/p>\n

FLOWS_FILES<\/span><\/span><\/p>\n

GSMUSER<\/span><\/span><\/p>\n

AUDSYS<\/span><\/span><\/p>\n

DVSYS<\/span><\/span><\/p>\n

OJVMSYS<\/span><\/span><\/p>\n

APPQOSSYS<\/span><\/span><\/p>\n

C##DBAAS_MONITOR<\/span><\/span><\/p>\n

WMSYS<\/span><\/span><\/p>\n

LBACSYS<\/span><\/span><\/p>\n

ANONYMOUS<\/span><\/span><\/p>\n

SI_INFORMTN_SCHEMA<\/span><\/span><\/p>\n

C##PDBMGR<\/span><\/span><\/p>\n

SPATIAL_WFS_ADMIN_USR<\/span><\/span><\/p>\n

SYSBACKUP<\/span><\/span><\/p>\n

CTXSYS<\/span><\/span><\/p>\n

OUTLN<\/span><\/span><\/p>\n

ORACLE_OCM<\/span><\/span><\/p>\n

APEX_REST_PUBLIC_USER<\/span><\/span><\/p>\n

GSMADMIN_INTERNAL<\/span><\/span><\/p>\n

MDDATA<\/span><\/span><\/p>\n

APEX_PUBLIC_USER<\/span><\/span><\/p>\n

ORDDATA<\/span><\/span><\/p>\n

SYSDG<\/span><\/span><\/p>\n

SYSKM<\/span><\/span><\/p>\n

XS$NULL<\/span><\/span><\/p>\n

DIP<\/span><\/span><\/p>\n

APEX_LISTENER<\/span><\/span><\/p>\n

SPATIAL_CSW_ADMIN_USR<\/span><\/span><\/p>\n

OLAPSYS<\/span><\/span><\/p>\n

SYSTEM<\/span><\/span><\/p>\n

ORDSYS<\/span><\/span><\/p>\n

DBSNMP<\/span><\/span><\/p>\n

ORDPLUGINS<\/span><\/span><\/p>\n

GSMCATUSER<\/span><\/span><\/p>\n

XDB<\/span><\/span><\/p>\n

SYS<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

39 rows selected.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

Local User<\/span><\/span>\ub294 \uc5b4\ub5a4 \uac83\uc774 \uc788\ub294 \uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. Root\u00a0<\/span>\ucee8\ud14c\uc774\ub108\uc5d0\ub294Local User <\/span>\uc0dd\uc131\uc774 \ubd88\uac00\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>select distinct username,con_id from cdb_users where
\ncommon = ‘NO’;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>CON_ID<\/span><\/span><\/p>\n

—————————— ——<\/span><\/span><\/p>\n

DBAAS_MONITOR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

SH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

PDBADMIN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

HR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

OE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

SCOTT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

PM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

BI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

IX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

9 rows selected.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

 <\/p>\n

CDB\u00a0<\/span><\/span>\uc758\u00a0Role <\/span>\uad6c\uc870\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. Root <\/span>\ucee8\ud14c\uc774\ub108\uc5d0\ub294Local Role <\/span>\uc0dd\uc131\uc774 \ubd88\uac00\ud569\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> <\/span>col role for a50<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select role,common,con_id from
\ncdb_roles;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>COM CON_ID<\/span><\/span><\/p>\n

————————————————– —
\n——<\/span><\/span><\/p>\n

CONNECT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

RESOURCE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

DBA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

AUDIT_ADMIN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

:<\/span><\/span><\/p>\n

:<\/span><\/span><\/p>\n

:<\/span><\/span><\/p>\n

DV_DATAPUMP_NETWORK_LINK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

DV_REALM_RESOURCE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

DV_REALM_OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

168 rows selected.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

 <\/p>\n

Privilege <\/span><\/span>\uad6c\uc870\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. Privilege<\/span>\uc758 \uacbd\uc6b0, Common <\/span>\ub610\ub294Local<\/span>\uc758 \uad6c\ubd84\uc774 \uc5c6\uae30 \ub54c\ubb38\uc5d0 \uad00\ub828 \ub515\uc154\ub108\ub9ac\ubdf0\uc5d0COMMON <\/span>\uce7c\ub7fc\uc774 \uc5c6\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> <\/span>desc sys.system_privilege_map<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>Null?\u00a0\u00a0\u00a0 <\/span>Type<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>—————————————– ——–
\n—————————-<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>PRIVILEGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NOT NULL NUMBER<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NOT NULL VARCHAR2(40)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>PROPERTY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NOT NULL NUMBER<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>desc sys.table_privilege_map<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0 <\/span>Null?\u00a0\u00a0\u00a0 <\/span>Type<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>—————————————– ——–
\n—————————-<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>PRIVILEGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NOT NULL NUMBER<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NOT NULL VARCHAR2(40)<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

 <\/p>\n

Privilege <\/span><\/span>\uc790\uccb4\ub294Common <\/span>\ub610\ub294Local\u00a0<\/span>\uad6c\ubd84\uc774 \uc5c6\uc73c\ub098, Privilege<\/span>\uac00 \ubd80\uc5ec\ub420 \ub54c\ub294 \uadf8 \uad6c\ubd84\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/span>\uc544\ub798system Privilege, object privilege\u00a0<\/span>\uad00\ub828 \ubdf0\uc5d0\ub294COMMON <\/span>\uce7c\ub7fc\uc774 \uc788\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

 <\/p>\n\n\n\n
\n

SQL> <\/span>desc cdb_sys_privs<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>Null?\u00a0\u00a0\u00a0 <\/span>Type<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>—————————————– ——–
\n—————————-<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>GRANTEE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(128)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>PRIVILEGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(40)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>ADMIN_OPTION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(3)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>COMMON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(3)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>CON_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NUMBER<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>desc cdb_tab_privs<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>Null?\u00a0\u00a0\u00a0 <\/span>Type<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>—————————————– ——–
\n—————————-<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>GRANTEE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(128)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>OWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(128)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>TABLE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(128)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>GRANTOR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(128)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>PRIVILEGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(40)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>GRANTABLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(3)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>HIERARCHY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(3)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>COMMON\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(3)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>VARCHAR2(24)<\/span><\/span><\/p>\n

\u00a0<\/span><\/span>CON_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>NUMBER<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/p>\n

\uc544\ub798 \ucffc\ub9ac\uc5d0\uc11c \uc54c \uc218 \uc788\ub4ef\uc774ROLE <\/span>\uc740COMMON\u00a0<\/span>\ub610\ub294LOCAL <\/span>\uc18d\uc131\uc73c\ub85c \ubd80\uc5ec\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n\n\n\n
\n

SQL> <\/span>set lines 120<\/span><\/span><\/span><\/p>\n

SQL> <\/span>col grantee for a30<\/span><\/span><\/span><\/p>\n

SQL> <\/span>col granted_role for a40<\/span><\/span><\/span><\/p>\n

SQL> <\/span>select grantee,granted_role,common,con_id from
\ncdb_role_privs where grantee=’SYSTEM’;<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

GRANTEE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>GRANTED_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>COM\u00a0\u00a0\u00a0\u00a0 <\/span>CON_ID<\/span><\/span><\/p>\n

——————————
\n—————————————- — ———-<\/span><\/span><\/p>\n

SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>DBA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>AQ_ADMINISTRATOR_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span><\/p>\n

SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>DBA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

SYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>AQ_ADMINISTRATOR_ROLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>YES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>3<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n

SQL> <\/span>exit<\/span><\/span><\/span><\/p>\n

Disconnected from Oracle Database 12c Enterprise Edition
\nRelease 12.1.0.2.0 – 64bit Production<\/span><\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP,
\nAdvanced Analytics<\/span><\/span><\/p>\n

and Real Application Testing options<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Multitenant \uc544\ud0a4\ud14d\uccd0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0c1\ud0dc\uc640 \ubc84\uc804 \uc815\ubcf4\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. \u00a0 [oracle@New-Features-12c ~]$ sqlplus \/ as sysdba \u00a0 SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 7 07:51:06 2015 \u00a0 Copyright (c) 1982, 2014, Oracle.\u00a0 All rights reserved. \u00a0 \u00a0 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, Oracle Label Security, OLAP, […]<\/p>\n","protected":false},"author":1,"featured_media":2336,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[20],"tags":[74,823],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/Oracle-12c-logo-New.png?fit=499%2C302","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2326"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2326"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2326\/revisions"}],"predecessor-version":[{"id":2329,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2326\/revisions\/2329"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2336"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2326"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}