| Thread | Last Post | Replies |
|
| loadjava - i'm puzzled | 20 Jun 2005 12:17 GMT | 1 |
I try to load a java.jar into a 9i database. It could load it into a 10g database but not into 9i..... I'm totally lost. Please find at the end the summary of the loading. Bevore I did the loadjava I've executed a dropjava
|
| Connecting ORACLE through Firewall | 20 Jun 2005 10:51 GMT | 10 |
I have set up an ORACLE 9.2.0.3 on a server in DMZ. I also installed the client runtime on a desktop in the company LAN. I used CMAN on the server side to fix the Net8 PORT that has been opened in our Firewall. One for connection instantiation (1521) and one for the client ...
|
| ORA-01658: unable to create INITIAL extent during import of a db | 20 Jun 2005 10:43 GMT | 7 |
Hello gents a have a proble when i try to export a dump from one db to a new More in detail i have 2 istance of Oracle 8.1.6 on solarsi 2.7 (both on the same server) Now i whant migrate the db from istance A) to istance B)
|
| Does HTML DB 1.6 work on an Oracle 9i instance ? | 19 Jun 2005 19:37 GMT | 4 |
I have a Windows XP Pro Machine on which i want to install Oracle 9i Release 2. I also want to install HTML DB 1.6. This is not a production environment. I am trying this at home. I can't find any documentation on Metalink that says HTML DB 1.6 is or is not compatible with 9i. May
|
| The user can still connect even after CREATE SESSION privilege is revoked | 19 Jun 2005 16:50 GMT | 7 |
I have revoked the CREATE SESSION privilege and the user can still connect. What needs to be done to prevent a user to connect to a database besides REVOKE CREATE SESSION FROM user?
|
| Use friendly Databse Tool for non-DBAs | 19 Jun 2005 15:41 GMT | 3 |
I was looking for databse tools that allow easy access to data for users with minimal or no DB knowledge to perform meainstream functions such as read/write/edit/delete data. Something like an editor perhaps, that will also have user previledges before he/she starts accessing
|
| execute immediate | 19 Jun 2005 14:12 GMT | 2 |
I built a dynamic query in PL/SQL when I did
> spool test.sql > ... |
| Oracle 9.2.0.1.0 Undo Management? | 19 Jun 2005 12:40 GMT | 5 |
undo_manager is auto I try this ... conn user/password@ora92 update sometable set field1='1234567890', field2='1234567890';
|
| oracle10g tools long time startup & network problem | 19 Jun 2005 10:06 GMT | 2 |
I have a problem with very long time startup of oracle tools like dbca, netmgr etc. on WinXp pro. I have two net interfaces - local net and external with dhcp. It's ok when I disable second of them. It looks like DNS problem, but I can't find a reason. The firewall is disabled.
|
| imp - BLOB - reduce imp time | 18 Jun 2005 20:18 GMT | 4 |
9.2.0.4 RHEL 3 Hi We have many tables that contain BLOBS and when it comes to move data
|
| RAC: where is the instance startup script? | 18 Jun 2005 19:22 GMT | 6 |
I've just installed RAC on Solaris and RedHat Linux and I was able to bring down and up the instances when I rebooted the servers. Where are the startup scripts located? The only scripts I'm aware of are the init.crs, init.cssd, init.evmd but those do not bring up the instances.
|
| How to know a table is being accessed by other session? | 18 Jun 2005 17:20 GMT | 8 |
How to know a table is being accessed by other session?
|
| migrating from 8.1.7 to 9i how to keep same user_id | 18 Jun 2005 17:18 GMT | 5 |
I've got hundreds of user_ids used in dozens of tables and we use the USER_ID as part of our application security and audit trail. I was in the habit of just moving the PWD.ORA file into a new database when both were 8.1.7 Will this work with different versions?
|
| Connecting using Olog() as sysdba | 18 Jun 2005 17:12 GMT | 6 |
I am using an old 7.x library call olog() to connect to Oracle. All is fine except I can't connect as sysdba. Basically, I have this call: r = olog(&lda, (ub1 *) hda, buf, -1, (text *) 0, -1, (text *)0, -1, (ub4)OCI_LM_DEF);
|
| Issues with OS and database performance | 18 Jun 2005 16:45 GMT | 3 |
We have a datawarehouse which has some performance issues. I am look for some reading material on how to analyze issues at the operating system level and correlating that with database performance. Specifically, I am looking for Red Hat Linux Operating system release 3
|