ITPub博客

首页 > 数据库 > Oracle > imp-导入小写字母的表

imp-导入小写字母的表

原创 Oracle 作者:xychong123 时间:2019-01-07 19:01:46 0 删除 编辑

# 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


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.



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.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

. . exporting table                            TS2     288657 rows exported

EXP-00091: Exporting questionable statistics.

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


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.



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 SCOTT's objects into SCOTT

. . importing table                      "emp_bak"         14 rows imported

Import terminated successfully without warnings.

```


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20747382/viewspace-2374829/,如需转载,请注明出处,否则将追究法律责任。

上一篇: lvm 名称冲突
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2015-06-10

  • 博文量
    118
  • 访问量
    64034