• oracle用户名小写时,利用sqlplus连接


    [oracle@upright92 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.4.0 Production on Tue May 22 10:39:34 2018

    Copyright (c) 1982, 2013, Oracle.  All rights reserved.

    Connected to:

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

    With the Partitioning, Oracle Label Security, OLAP, Data Mining

    and Real Application Testing options

    SQL> conn "wqq"/wqq

    Connected.

    [oracle@upright92 ~]$ sqlplus "wqq"/wqq

    SQL*Plus: Release 11.2.0.4.0 Production on Tue May 22 10:39:18 2018

    Copyright (c) 1982, 2013, Oracle.  All rights reserved.

    Connected to:

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

    With the Partitioning, Oracle Label Security, OLAP, Data Mining

    and Real Application Testing options

    [oracle@upright92 ~]$ sqlplus '"wqq"/wqq'

    SQL*Plus: Release 11.2.0.4.0 Production on Tue May 22 10:22:22 2018

    Copyright (c) 1982, 2013, Oracle.  All rights reserved.

    Connected to:

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

    With the Partitioning, Oracle Label Security, OLAP, Data Mining

    and Real Application Testing options

    [oracle@upright92 ~]$ exp '"wqq"/wqq' file=2.dump tables=tab GRANTS=Y 

    Export: Release 11.2.0.4.0 - Production on Tue May 22 10:34:09 2018

    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, Oracle Label Security, 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)

    About to export specified tables via Conventional Path ...

    . . exporting table                            TAB          0 rows exported

    Export terminated successfully without warnings.

  • 相关阅读:
    C++之容器
    C++之复制控制
    TCP的3次握手/4次握手
    linux编程之多线程编程
    linux编程之信号
    linux编程之共享内存
    MySQL数据库优化
    MySQL存储引擎InnoDB与Myisam
    Redis--持久化
    Redis 请求应答模式和往返延时 Pipelining
  • 原文地址:https://www.cnblogs.com/wangqianqiannb/p/9071729.html
Copyright © 2020-2023  润新知