点击OK
Manage Schema Data
1. Create a new table in the HR schema in the PROD database with the following specifications: 1.1 Table name MAGAZINE_ARTICLES 1.2 Tablespace USERS 1.3 Column names
1.3.1 AUTHOR VARCHAR2(30)
1.3.2 ARTICLE_NAME VARCHAR2(50) 1.3.3 ARTICLE_DATE DATE 1.3.4 ARTICLE_DATA CLOB
1.3.4.1 Tablespace LOB_DATA with a 16KB chunk size,initial and next extents each with a size of 2MB.
1.3.4.2 Use the nocache option and disable storage in row.
1.4 Use import to populate the HR.MAGAZINE_ARTICLES table with data from the exp_mag.dmp file.
方法一：用GC图形界面：
方法二：用Sqlplus命令行，以hr身份登录PROD，执行以下SQL语句： CREATE TABLE MAGAZINE_ARTICLES ( AUTHOR VARCHAR2(30), ARTICLE_NAME VARCHAR2(50), ARTICLE_DATE DATE, ARTICLE_DATA CLOB
)
TABLESPACE USERS LOB(ARTICLE_DATA) STORE AS (TABLESPACE LOB_DATA STORAGE (INITIAL 2m NEXT 2m) CHUNK 16384 NOCACHE DISABLE STORAGE IN ROW);
生成exp_mag.dmp文件：
SQL> insert into hr.magazine_articles values('prince','MY BOOK',sysdate,'I am princeOracle9iOracle9iOracle9i'); 1 row created.
SQL> insert into hr.magazine_articles values('prince360','prince',sysdate,'ABCDEFG'); 1 row created.
SQL> commit; Commit complete.
[oracle@rac1 ~]$ expdp hr/oracle@prod directory=dir dumpfile=exp_mag.dmp tables=MAGAZINE_ARTICLES