Geek Answers Handbook

Sybase: Can't create a database: why not?

It should be easy.

Sybase docs ("Example 1") say that you do not need to specify a parameter size, but even if I do this:

create database pubs5 on default = '10M'

I still get the error message:

Could not execute statement.
CREATE DATABASE failed because of incorrectly specified or unavailable
space. Total number of megabytes specified and available must be at
least 6 megabytes so Model Database can be copied to the new database.
SQLCODE=1810

I tried different sizes (just 6 MB each), deleting the size and trying double quotes, single quotes and without quotes.

Why is it so hard?

Thank.

+4
source share
2 answers

The syntax is correct, but there is not enough space on your Sybase database device that is marked as the default.

The easiest way to solve it is as follows:

disk resize name='master', size='20m'

create database pubs5 on master = '10M'

20 , . " ".

+4

, - , , model, sybsystemprocs, sybsystemdb, tempdb.

pubs5 = '10M'

()

disk init / dbs.

0

More articles:


All Articles