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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Working with database files

 

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. See ALTER DBSPACE statement.

The DB_EXTENDED_PROPERTY function also accepts the predefined dbspace names. See DB_EXTENDED_PROPERTY function [System].