Oninit cdi / Archive
Talk to an expert →

database in blobspaces/sblobspaces------WebKitForm

Posted in 2009

Topics: Storage & Space Management

SARAVANAN — — source: IIUG Forums & Mailing Lists

Creating a database in dbspaces, is the right way ? else Can we create database in blobspaces, sblobspaces ?? ------WebKitFormBoundary3aVAC6CdyMTFn+pu

↪ replying to SARAVANAN
Art Kagel — — source: IIUG Forums & Mailing Lists

No. A database, or for that matter a permanent table or index, can only be created in a 'normal' dbspace. Temp tables and their indexes can be created in temp dbspaces, but still not in blobspace or sblobspace. You can only place Simple Large Object columns within a table can be placed into a Blobspace and only Smart Large Object columns within a table can be placed into a Smart Blobspace, not the tables and databases themselves. The only exception to that would be if you created a Virtual Table Interface (VTI) table type that lives in a smart blobspace, but you would have to code all of the support routines yourself and the database that contained the tables would still have to live in a regular dbspace. Why? What problem are you trying to solve? Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Aug 3, 2009 at 10:24 AM, <> wrote: > Creating a database in dbspaces, is the right way ? > else Can we create database in blobspaces, sblobspaces ?? > > ------WebKitFormBoundary3aVAC6CdyMTFn+pu > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5ab40e4f99c04703e5ab9

↪ replying to SARAVANAN
Everett — — source: IIUG Forums & Mailing Lists

> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] > Sent: Monday, August 03, 2009 9:24 AM > To: ids@iiug.org > Subject: database in blobspaces/sblobspaces------WebKit.... [16555] > > Creating a database in dbspaces, is the right way ? > else Can we create database in blobspaces, sblobspaces ?? Yes, creating your databases in dbspaces is the right thing to do (preferably not rootdbs though). I haven't tried it, but it is likely impossible to create a database in blobspace. --EEM > > ------WebKitFormBoundary3aVAC6CdyMTFn+pu > > > ************************************************************************ ****** > * > Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary