Oracle Database - Special Characters

> Database > Oracle Database

1 - Question mark (?)

In Oracle Database files and programs, a question mark (?) represents the value of the ORACLE_HOME environment variable. For example, Oracle Database expands the question mark in the following SQL statement to the full path of the Oracle home directory:

SQL> ALTER TABLESPACE TEMP ADD DATAFILE '?/dbs/temp02.dbf' SIZE 200M

2 - At sign (@)

Similarly, the at sign (@) represents the ORACLE_SID environment variable. For example, to indicate a file that belongs to the current instance, run the following command:

SQL> ALTER TABLESPACE tablespace_name ADD DATAFILE [email protected].dbf

You can create a syslog audit trail to track administrative activities.

Advertising
db/oracle/special_character.txt · Last modified: 2017/09/06 19:29 by gerardnico