Search results for query: *

I have a lob (fname) with an index on it. How do I move the index from tablespace_B and to tablespace_A. My understanding is that you cannot alter or drop lob indexes.

I want to write a materialized view to select all the data from a master table but I want the view not to execute until I execute it. Do I still need the parameters START WITH and NEXT? How do I write the view?

How do I point the children records to the correct parent once the parent key is changed?

I need help with the sql statement to do the following - 2 tables are linked-contacttbl & addrtbl. The contact table contains a unique uid yet duplicate names. The addr table contains the contact-uid as foreign key. I know how to delete duplicate records. What I need help with is - I need to...

I need help with the sql statement to do the following - 2 tables are linked-contacttbl & addrtbl. The contact table contains a unique uid yet duplicate names. The addr table contains the contact-uid as foreign key. I know how to delete duplicate records. What I need help with is - I need to...

I can't find how to hyperlink. Is hyperlinking an option in CR7? If not what is the work-around? Thanks for your help!

I have been asked to reveiw an instance and provide scripts that will make it a query-only instance. How do I do that?

When I run csscan I get the following error message: csscan system/manager full=y tochar=utf8 array=10240 process=3 /usr/lib/dld.sl: Can't find path for shared library: libwtc8.sl /usr/lib/dld.sl: No such file or directory Abort(coredump) What is the library...

I'm looking for someone with experience going from WE8ISO8859P1 to UTF8. I'm not sure of the steps involved and I would appreciate some help on this. Also, what problems will occurr if i have datatypes of BLOB and CLOB? Are there any conversion problems I need to be aware of with the data in...