SQL Anywhere uses the following predefined dbspaces for its databases:
|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].
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|