SQL Anywhere database - Help with dbspaces

Author

Help with dbspaces

Jon Springs

2005-04-13, 8:23 pm

Here is what I want to do and have not found a way to do it.

ASA 9.0, Win2k.

I have a SYSTEM dbspace on one drive and and eval dbspace on a second drive.

I want rebuild the SYSTEM dbspace and attach the existing eval dbspace to
the new SYSTEM dbspace. Is this possible? I am getting 'dbspace belongs to
another database' or 'cannot open dbspace' errors with everything I've
tried.

Thanks,

-----Jon Springs-----

Chris Keating $iAnywhere Solutions$

2005-04-13, 8:23 pm

This is generally not a option.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

********************
********************
********************
*****************

"Jon Springs" <jsprings@jontanshe.org> wrote in message
news:425d6d9e$1@foru
ms-1-dub...
> Here is what I want to do and have not found a way to do it.
>
> ASA 9.0, Win2k.
>
> I have a SYSTEM dbspace on one drive and and eval dbspace on a second
> drive.
>
> I want rebuild the SYSTEM dbspace and attach the existing eval dbspace to
> the new SYSTEM dbspace. Is this possible? I am getting 'dbspace belongs to
> another database' or 'cannot open dbspace' errors with everything I've
> tried.
>
> Thanks,
>
> -----Jon Springs-----
>
>

Jon Springs

2005-04-13, 8:23 pm

Generally? Does that mean there might be a one-time option or something?

Is there any way to dump the contents of a dbspace without it's hosting
SYSTEM dbspace?

-----Jon-----

"Chris Keating (iAnywhere Solutions)" < FightSpam_keating@iA
nywhere.com>
wrote in message news:425d9929@forums
-1-dub...
> This is generally not a option.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> ********************
********************
********************
*****************
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> ********************
********************
********************
*****************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> ********************
********************
********************
*****************
>
> "Jon Springs" <jsprings@jontanshe.org> wrote in message
> news:425d6d9e$1@foru
ms-1-dub...
>
>

John Smirnios

2005-04-14, 11:24 am

It is never an option. The system dbspace contains information about
other dbspaces (locations of tables, indexes, free lists, etc). No
mix-and-match is possible.

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Jon Springs wrote:
> Generally? Does that mean there might be a one-time option or something?
>
> Is there any way to dump the contents of a dbspace without it's hosting
> SYSTEM dbspace?
>
> -----Jon-----
>
> "Chris Keating (iAnywhere Solutions)" < FightSpam_keating@iA
nywhere.com>
> wrote in message news:425d9929@forums
-1-dub...
>
>
>

Jon Springs

2005-04-18, 8:23 pm

John,

I may not have made myself clear on what it is I need.

I have a dbspace ('dbspace1') that I want to unload. Not knowing all the ins
and outs of how ASA9 handles or restricts the use of dbspaces (tehre iare
one or to pages only in the documentation, creating and deleting) , I
merrily deleted the file 'dbspace1' from it's directory without first
dropping it's table and then dpspace. Now, dbsrv9, when trying to start the
database, notifies me that it cannot find 'dbspace1' and continues to
startup.

I would like to create a new database, attach 'dbspace1' to it and proceed
to unload the tables in 'dbspace1'. I can't seem to be able to do this.

Thanks,

-----Jon-----

"John Smirnios" < smirnios_at_sybase_d
ot_com> wrote in message
news:425e8e23$1@foru
ms-2-dub...
> It is never an option. The system dbspace contains information about other
> dbspaces (locations of tables, indexes, free lists, etc). No mix-and-match
> is possible.
>
> -john.
>
> --
> John Smirnios
> Senior Software Developer
> iAnywhere Solutions Engineering
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
>
>
> Jon Springs wrote:
>

John Smirnios

2005-04-19, 8:23 pm

Okay, I assumed the question in this thread was independent of your
question in your other thread. You're not just trying to replace a
dbspace because you think it would be a neat feature. For context, I'll
make another posting about your real problem in that other thread.

-john.

--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

Jon Springs wrote:

> John,
>
> I may not have made myself clear on what it is I need.
>
> I have a dbspace ('dbspace1') that I want to unload. Not knowing all the ins
> and outs of how ASA9 handles or restricts the use of dbspaces (tehre iare
> one or to pages only in the documentation, creating and deleting) , I
> merrily deleted the file 'dbspace1' from it's directory without first
> dropping it's table and then dpspace. Now, dbsrv9, when trying to start the
> database, notifies me that it cannot find 'dbspace1' and continues to
> startup.
>
> I would like to create a new database, attach 'dbspace1' to it and proceed
> to unload the tables in 'dbspace1'. I can't seem to be able to do this.
>
> Thanks,
>
> -----Jon-----
>
> "John Smirnios" < smirnios_at_sybase_d
ot_com> wrote in message
> news:425e8e23$1@foru
ms-2-dub...
>
>
>

Sponsored Links