Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 591

e xeRCiSe 13.1 (continued)
SQL> CREATE TABLESPACE example;
Tablespace created.
SQL> CREATE USER hr IDENTIFIED BY hr DEFAULT TABLESPACE example;
User created.
SQL> GRANT UNLIMITED TABLESPACE TO hr;
Grant succeeded.
SQL>
#### $ORACLE_HOME\NETWORK\ADMIN\tnsnames.ora
#### tnsnames.ora entry for the new PDB
#### CONT.lne6
LNE6 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LNE6)
)
)
3. Start up the source non-CDB. For this example, we'll use the ORCL database. Alter the
non-system tablespaces to read-only mode (if possible) for a consistent export.
C:\>Set ORACLE_SID=ORCL
C:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Feb 2 11:08:21 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5027536896 bytes
Fixed Size 2412928 bytes
Variable Size 704646784 bytes
Database Buffers 4311744512 bytes
Redo Buffers 8732672 bytes
Database mounted.
Database opened.
SQL> SELECT tablespace_name FROM dba_tablespaces;