Shulou(Shulou.com)06/01 Report--

Share today, spent a day in the bank today, can have a rest tomorrow, I wish you all a good weekend!

If you see the following ways of writing, what will you think? What's the difference?

Tell you that these writing methods can log in to the database by default.

$sqlplus xxx/xxx as sysdba$sqlplus roidba/roidba as sysdba$sqlplus / as sysdba$sqlplus'! @ # /! As sysdba'

Here are a few small points of knowledge worth paying attention to.

1. Oracle uses system authentication by default and logs in to the database.

2. Single quotation marks emphasize ignoring all special characters here, which is why sometimes we need single quotation marks and sometimes we don't.

When we do database backup, sometimes we use sys, sometimes we use system, sometimes we have business users to do logical backup, and I don't want to expose my password, what should I do?

Many friends just use expdp\'/ as sysdba\'.

For example

$expdp\'/ as sysdba\ 'Export: Release 12.1.0.2.0-Production on Fri Dec 15 22:42:17 2017Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP Advanced Analytics and Real Application Testing optionsStarting "SYS". "SYS_EXPORT_SCHEMA_01": "/ * AS SYSDBA" Estimate in progress using BLOCKS method...Total estimation using BLOCKS method: 0 KBProcessing object type SCHEMA_EXPORT/STATISTICS/MARKERORA-31655: no data or metadata objects selected for jobJob "SYS". "SYS_EXPORT_SCHEMA_01" completed with 1 error (s) at Fri Dec 15 22:42:43 2017 elapsed 0 00:00:24

Where do you get xxx users? don't be fooled.

Sqlplus xxx/xxx as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 15 22:44:20 2017Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing optionsSYS@orcl1 > select user from dual;USER--SYS

Where did it come from?! @ # users, ha, now you should understand that what you see may not be true, and you can only come to a final conclusion by testing and verifying it yourself.

$sqlplus'! @ # /! As sysdba'SQL*Plus: Release 12.1.0.2.0 Production on Fri Dec 15 22:45:35 2017Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing optionsSYS@orcl1 > select user from dual;USER--SYSSYS@orcl1 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.