# 1建立測試表“emp_bak"

>使用雙引號建立的表，預設為小寫字母的表.

```

SQL> create table "emp_bak" as select * from emp;

Table created.

SQL> slect * from tab;

SP2-0734: unknown command beginning "slect * fr..." - rest of line ignored.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

BONUS TABLE

DEPT TABLE

EMP TABLE

E_TMP TABLE

OD TABLE

OUTPUT TABLE

OUTPUT2 TABLE

SALGRADE TABLE

TS1 TABLE

TS2 TABLE

emp_bak TABLE

13 rows selected.

```

# 小寫字母表特點

查詢需要使用單引號：

```

SQL> select count(*) from emp_bak;

select count(*) from emp_bak

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select count(*) from "emp_bak";

COUNT(*)

----------

14

```

#是否可以建立同名大寫的表？

```

SQL> create table emp_bak as select * from emp;

Table created.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

BONUS TABLE

DEPT TABLE

EMP TABLE

EMP_BAK TABLE

E_TMP TABLE

emp_bak TABLE

```

# 如何單獨匯入小寫字母的表呢？

# exp 全使用者匯出

```

[oracle@prod04 ~]$ exp scott/snow file=snow1.dmp

Export: Release 11.2.0.4.0 - Production on Mon Jan 7 18:54:29 2019

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user SCOTT

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user SCOTT

About to export SCOTT's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export SCOTT's tables via Conventional Path ...

. . exporting table BONUS 0 rows exported

. . exporting table DEPT 4 rows exported

. . exporting table EMP 14 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table EMP_BAK 14 rows exported

. . exporting table E_TMP 14 rows exported

. . exporting table OD 4 rows exported

. . exporting table OUTPUT 5 rows exported

. . exporting table OUTPUT2 3 rows exported

. . exporting table SALGRADE 5 rows exported

. . exporting table TS1 7585 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table TS2 288657 rows exported

EXP-00091: Exporting questionable statistics.

. . exporting table emp_bak 14 rows exported

. exporting synonyms

. exporting views

. exporting stored procedures

. exporting operators

. exporting referential integrity constraints

. exporting triggers

. exporting indextypes

. exporting bitmap, functional and extensible indexes

. exporting posttables actions

. exporting materialized views

. exporting snapshot logs

. exporting job queues

. exporting refresh groups and children

. exporting dimensions

. exporting post-schema procedural objects and actions

. exporting statistics

Export terminated successfully with warnings.

```

#解決方法：

```

[oracle@prod04 ~]$ imp scott/snow file=snow1.dmp tables='\"emp_bak\"'

Import: Release 11.2.0.4.0 - Production on Mon Jan 7 18:45:02 2019

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

. importing SCOTT's objects into SCOTT

. . importing table "emp_bak" 14 rows imported

Import terminated successfully without warnings.

```

imp-匯入小寫字母的表

相關文章