Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Working with database files


Pre-defined dbspaces

SQL Anywhere uses the following pre-defined dbspaces for its databases:

Dbspace Name
Main database file system
Temporary file temporary or temp
Transaction log file translog
Transaction log mirror translogmirror

You cannot create user-defined dbspaces with these names and you cannot drop the pre-defined dbspaces.

If you upgrade a version 10.0.0 or earlier database with user-defined dbspaces that use the pre-defined dbspace names, then all references to these dbspaces in SQL statements are assumed to be referring to the user-defined dbspaces, and not the pre-defined dbspaces. The only way that you can refer to the pre-defined dbspaces is by dropping the user-defined dbspaces, or renaming them to not use the same names as the pre-defined dbspaces.

The ALTER DBSPACE statement supports the pre-defined dbspace names so you can add more space to them. See ALTER DBSPACE statement.

The DB_EXTENDED_PROPERTY function also accepts the pre-defined dbspace names. See DB_EXTENDED_PROPERTY function [System].