Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "Analysis of the problems existing in adding double quotes when creating data objects in the database". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations! I hope you can read it carefully and be able to achieve something!

problem

When a developer colleague creates tablespace An in oracle, then creates user user_a and specifies tablespace A, the prompt tablespace does not exist.

After looking at his statement to create the tablespace, I find that the sql statement is similar to the following:

CREATE TABLESPACE "a" DATAFILE

'/ u01Applicon SIZE oracleUniplex oradata SIZE 100G Universe orclinct users01.dbf' Universe 5242880

AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M

Cause analysis

Because the statement to create the tablespace is automatically generated by the application, and the tablespace name is enclosed in double quotes, the case of the name under the double quotation marks is sensitive.

In other words, create tablespace a XXX and create tablespace "a" XXX are actually two different objects in the database.

The objects created by oracle are capitalized by default, and the following two statements are equivalent:

CREATE TABLESPACE "A" DATAFILE

'/ u01Applicon SIZE oracleUniplex oradata SIZE 100G Universe orclinct users01.dbf' Universe 5242880

AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M

CREATE TABLESPACE a DATAFILE

'/ u01Applicon SIZE oracleUniplex oradata SIZE 100G Universe orclinct users01.dbf' Universe 5242880

AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M

But the above statement is different from the following:

CREATE TABLESPACE "a" DATAFILE

'/ u01Applicon SIZE oracleUniplex oradata SIZE 100G Universe orclinct users01.dbf' Universe 5242880

AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M

This is the end of the content of "Analysis of the problems existing in double quotation marks when creating data objects in the database". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.