Forum OpenACS Q&A: Oracle Tablespaces and LOBs

Posted by C. R. Oldham on 05/13/03 01:01 AM

Greetings,

Does anyone know (off the top of your head) if there is any way to fix the problem with importing schemas into Oracle that have LOBs in them? The LOBs want to return to the same tablespace that they came from, which is a problem for example if you setup a different schema that stores it's data in a different tablespace.

I can't find a succinct definition or solution to this problem in MetaLink.

I'm on Oracle 8.1.7 r4.

Thanks

--cro

2: Re: Oracle Tablespaces and LOBs (response to 1)

Posted by Janine Ohmer on 05/13/03 03:39 AM

CR, check out this thread: http://openacs.org/forums/message-view?message_id=32957 - it contains the magic incantation you seek.

3: Re: Oracle Tablespaces and LOBs (response to 1)

Posted by C. R. Oldham on 05/13/03 04:21 PM

Janine,

Thank you so much. I had searched the forums but did not find that thread. That was exactly what I needed.

4: Re: Oracle Tablespaces and LOBs (response to 1)

Posted by Janine Ohmer on 05/13/03 04:32 PM

You are very welcome!

I have my doubts about the search facility these days. Most often I end up finding threads by looking at the posting history of someone I know was a participant - not exactly what I'd call an efficient method, but it seems to work better than searching for keywords.

5: Re: Oracle Tablespaces and LOBs (response to 4)

Posted by David Cotter on 05/14/03 11:29 AM

I agree about the search - I am finding it more difficult to find the info I want.

6: Re: Oracle Tablespaces and LOBs (response to 1)

Posted by Dave Bauer on 05/14/03 12:38 PM

David and Janine,

I just wantd to let you know that Tilmann Singer recenetly updated the forums search code on openacs.org to return one result per thread, instead of one result per reply which was giving out pretty useless search results. We just added this last week, so you might want to try it again.

Hopefully we will make even more improvements to search on openacs.org and in the toolkit.

7: Re: Oracle Tablespaces and LOBs (response to 6)

Posted by Tilmann Singer on 05/14/03 01:24 PM

But the messages that have been posted before that change are still indexed the old way AFAIK, we are waiting until it is possible to do a full reindexing.