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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Working with Database Files

Working with Database Files Next Page

Overview of database files

Basic database files

Each database has the following files associated with it:

Pre-defined dbspaces

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

Main database fileSYSTEM
Temporary fileTEMPORARY or TEMP
Transaction log fileTRANSLOG
Transaction log mirrorTRANSLOGMIRROR

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 above 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].

Additional files

Other files can also become part of a database system, including: