Search results for query: *

There are a couple of options you can use here... 1) Externally authenticated users. Rather than having Oracle managed passwords, user accounts are set up to accept credentials presented by the operating system (i.e. the client Windows machine) to authenticate the user. 2) Oracle Internet...

My understanding, though, is that profiles follow the user executing the procedure, not the procedure itself. Thus, if SUPER_USER and LOW_RESOURCE_USER both execute a procedure owned by SUPER_USER, their respective profiles will control the priority, not the profile of the object owner.

Note that the ALTER DATABASE command will fail unless the target character set is a strict superset of the source character set.

Profiles are user-based, not object-based.

Unless AR8MSWIN1256 is a strict superset of WE8ISO8859P1 (and I don't believe it is), I believe you'll have to create a new database instance and do a full export and import.

It appears that you need to update your MDAC. The ODBC Driver Manager that's part of your current MDAC install doesn't know that ODBC 3.52 is a valid version of the ODBC API. You can grab the latest version of the MDAC from http://www.microsoft.com/data Also, if you have the 9.2 Oracle...

I'd tend to be wary about performance as well. There's a non-trivial overhead for every JNI call, which may tend to make operations that are normally very cheap significantly more expensive. Justin

The standard approach would be to have a separate detail table for this sort of thing, i.e. Table emp has a primary key empno Table emp_phone has a column empno, a foreign key to the emp table, and a phone number column If an employee has only one phone number, there would be only one row in...

Why would you be eliminating the optimal option? In most situations I've seen, I'd be for increasing that value, not decreasing it. What sort of activity is your database doing? Are you sure you understand why the ORA-01555 errors are happening? Justin

There are a couple of options. First, you can install Oracle Heterogenous Services/ Oracle Transparent Gateway. This allows Oracle to create a database link to non-Oracle databases which you can query just like any other database link. Second, if Interbase provides a type 4 (thin) JDBC...

Start at http://otn.oracle.com (at some point, you'll need a free account if you don't already have one). - Click on the Downloads link in the upper right-hand corner nav bar - Click on the Oracle 9i database (or Oracle 8i if that's the flavor you're after) - Choose the proper operating system -...

Actually, if anything, implicit cursors will tend to be faster, though this difference is likely to be miniscule. Tom Kyte has a couple of discussions on this http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1205168148688...

For Windows, Oracle does provide a separate client-only download option that's significantly smaller than the full-blown install. You can create a response file for the Oracle Universal Installer that will allow the OUI to be run without human intervention. If you use InstallShield to install...

The other option, if there is a type 4 (thin) JDBC driver for Paradox, is to load that driver into Oracle's JVM and write Java stored procedures to access the data. Justin

What, exactly, are you looking to do with Oracle? Are you looking to learn how to be a DBA? How to develop PL/SQL applications? What sort of a background do you have-- Are you coming from another relational database? Are you familiar with other languages? Did you take some database theory...

I believe that the OCI_THREADED attribute is required in this situation (but someone taking a detailed look at the OCI Programmer's Reference on http://tahiti.oracle.com might well prove this belief wrong). I would generally think that a 7-8% performance loss would be about right for 4 threads...

What sort of performance difference are we talking about-- 5% or 50%? In general, since OCI would have to have some sort of locking or synchronization on the environment's data structures, I'd expect that N threads would behave slightly worse than N processes, but that it wouldn't be a...

All Oracle's documentation is available at http://tahiti.oracle.com. The 9i Net Services Administrator's Guide http://otn.oracle.com/pls/db92/db92.show_toc?partno=a96580&remark=drilldown&word=tnsnames.ora will have all the information you could hope for. Justin