473,326 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

LONG RAW AND #TABLESPACE

Hi,

can you help me ?
My problem is :
I have two tablespaces (sdata0 and sdata1)
On the first tablespace (sdata0) I would to store all the data except
long raw data and on the second tablespace (sdata1) I would to store
the long raw data

This code works fine
create table "testlob" (ID number, NAME NVARCHAR(50), BINCOL BLOB)
tablespace sdata0
lob(BINCOL ) store as (tablespace sdata1)

BUT I can't do that when the column BINCOL is LONG RAW type

(Unfortunately,I can't use BLOB instead the LONG RAW)

Thank you for the help.

MB
Jul 19 '05 #1
1 2763

"M Bouloussa" <mb@asterop.com> wrote in message
news:ab************************@posting.google.com ...
Hi,

can you help me ?
My problem is :
I have two tablespaces (sdata0 and sdata1)
On the first tablespace (sdata0) I would to store all the data except
long raw data and on the second tablespace (sdata1) I would to store
the long raw data

This code works fine
create table "testlob" (ID number, NAME NVARCHAR(50), BINCOL BLOB)
tablespace sdata0
lob(BINCOL ) store as (tablespace sdata1)

BUT I can't do that when the column BINCOL is LONG RAW type

(Unfortunately,I can't use BLOB instead the LONG RAW)

Thank you for the help.

MB


Can't do that with a long raw. Why can't you use a blob? The closes you
could do is create 2 tables and the long raw table is in the other
tablespace with a key to the first. (messy. but possible) Probably could do
a view to make it look like 1 table.
Jim
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: sandeep G | last post by:
I've a table which has a number & a blob column, both of which are NOT NULL type. This table is composite partitioned using range & hash on the same column. Each partition is sub partitioned into...
1
by: Galina | last post by:
Hello I am trying to create a table, which includes a field type LONG. The wizard hasn't allowed me to enter storage settings for this table. It set the initial size is 64K and not available to...
7
by: Galina | last post by:
Hello I am going to copy a data from MS Access table into Oracle table. One of fields is memo type and data in this field range from 1 character to 551 long string. Do I need to create a field...
6
by: robert | last post by:
just got out of a "class" on EXPLAIN, from a 390/v6 maven. was told that ACCESSTYPE = 'R' in the plan_table meant a TableSpace scan. hmmmm. next step up (or down, depending on your outlook)...
4
by: Joachim Klassen | last post by:
DB2 V8.2 FP10 on Windows I tested the following HADR scenario: - a new tablespace on a new filesytem is created on the primary System - the replay on standby fails because of lacking permissions...
2
by: Raghava | last post by:
hi all, i was working on DB2 and came across an issue. i.e. can a tablespace be rollforwarded to POINT-IN-TIME? the scenario is as follows: i created a data base and a tablespace in it. i have...
2
by: vj_dba | last post by:
Hi Group, I have a problem in restoring my tablespace, my database is running in ARCHIVAL logging, I created a tablespace, did some transaction, then took the ONLINE BACKUP of the tablespace....
3
by: rdudejr | last post by:
Hi all, Ive got a script Ive built which runs reorgs on all tables needing it based on output of reorgchk. The reorgs are ran inline. This past weekend, the reorgs were running against 450...
1
by: M Bouloussa | last post by:
Hi, can you help me ? My problem is : I have two tablespaces (sdata0 and sdata1) On the first tablespace (sdata0) I would to store all the data except long raw data and on the second...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.