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

e xeRCiSe 13.1 (continued)
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
USER_TEST
10 rows selected.
SQL> ALTER TABLESPACE users READ ONLY;
Tablespace altered.
SQL> ALTER TABLESPACE example READ ONLY;
Tablespace altered.
SQL> ALTER TABLESPACE user_test READ ONLY;
Tablespace altered.
SQL> CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS 'c:\temp';
Directory created.
SQL> EXIT
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
C:\>
4. Begin the Data Pump export process. We have chosen a full database export here,
but you can also selectively export at the schema level.
expdp system/system FULL=y DUMPFILE=ncdb_expdat.dmp DIRECTORY=data_pump_dir
LOGFILE=export.log
Export: Release 12.1.0.1.0 - Production on Sun Dec 8 17:32:25 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.