Search results for query: *

We are off of the posted topic, but in Oracle8i rel 2 (8.1.6), Oracle has added a new initialization parameter, CURSOR_SHARING = { FORCE  ¦  EXACT }.  Setting it to EXACT gives the current mode of operation where only exact matches cause cursor...

I think that you are running into a problem with exceeding the max_rollback_segments init parameter. The default value for this parameter is 30, which would include the system rollback segment and any other rollback segments that you try to bring online. From the Oracle7 Server Reference...

Probably due to disk access. Your process is waiting for the OS to return data. I assume that you are using sql trace and tkprof. Look for the DISK column in the report for the number of physical disk reads needed.<br> <br> call count cpu elapsed disk query current...

I think that you will find that you imported the object into the SYSTEM users schema. If you want to import into CENTRAL you need to either run the import under that userid<br> (imp80 central/password@rms) or use the FROMUSER parameter to specify the user central. You can also add TOUSER but...

I support some Digital Unix systems and I agree with Mike that V8 does require more resources than V7 did so I would check that out first.<br> <br> But also, in VMS, not HPUX, so kind of a long shot but...<br> <br> If you are importing some procedures...<br> We have gotten a similar error trying...

First, I would not use LONG columns but LOBs (Large OBjects), which are new to V8. BLOBs are for binary data, and CLOBs are for character data. There are also NCLOBs for multibyte character sets and BFILE, which is a pointer to an external file. BLOBs, CLOBs and NCLOBs can be up to 4Gb in...

First, I would not use LONG columns but LOBs (Large OBjects), which are new to V8. BLOBs are for binary data, and CLOBs are for character data. There are also NCLOBs for multibyte character sets and BFILE, which is a pointer to an external file. BLOBs, CLOBs and NCLOBs can be up to 4Gb in...

I know of no limit to the number of users on NT except the power ofthe box to support it and the amount of memory you have. With that many users you would probably want to take alook at the Multi-Threaded Server (MTS).

You can find a list of the x$ and v$ tables/views in v$fixed_table and v$fixed_view_definition tables. The x$ tables are only accessable from the SYS userid in oracle. The v$'s are really views based on the x$ tables. You can see the view text in the v$fixed_view_definition table. I think...