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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types

 

Predefined dbspaces

SQL Anywhere uses the following predefined 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 predefined dbspaces.

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

The ALTER DBSPACE statement supports the predefined dbspace names so you can add more space to them.

The DB_EXTENDED_PROPERTY function also accepts the predefined dbspace names.

 See also