Lotus Domino Database Structure
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
0 pts.
Oracle sql statement log
Hi, We're currently trying to debug an application that is running queries thru jdbc/oci against our oracle 9.2 DB. While we have no way of finding out what is going on in the application we would like to trace all the sql statements that are run against our database (including 'select'...
Hi, We're currently trying to debug an application that is running queries thru jdbc/oci against our oracle 9.2 DB. While we have no way of finding out what is going on in the application we would like to trace all the sql statements that are run against our database (including 'select'...
Urgent Help: web-Forms 6i don't work after Upgrading the db from 8i to 10g
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....
Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....
Urgent Help
I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB...
I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB...
sql update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
Please I need an sql command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype.My oracle database is on windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
error in connection between oracle8i&developer2000
I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...
I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...
problem in installing the second oracle home
Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...
Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...
ORACLE NOT RECOGNIZING NEW RAM
We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size...
We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size...
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
cannot drop the user
Hi, I cannot drop the user. dorp user "USERA" cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method...
Hi, I cannot drop the user. dorp user "USERA" cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method...
svchost.exe
When I was working with win 2000 advanced server, suddenly it became slower and I started checking the running processes using task manager and I found 4 svchost.exe are running and one of them with PID:916 was using 38000K memory. After sometime the server became normal and everything is OK now....
When I was working with win 2000 advanced server, suddenly it became slower and I started checking the running processes using task manager and I found 4 svchost.exe are running and one of them with PID:916 was using 38000K memory. After sometime the server became normal and everything is OK now....
Error on installing Oracle 10 software where Oracle 9i software already exists
Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...
Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...
inserts through a database link
Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance...
Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance...
SQL Server restore job fails
I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013,...
I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013,...
Using optimizer hints in Forms
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...
Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...
Locked objects, Stored Procedures, Triggers, etc
We have a custom migration system for Oracle Objects but it simply tries to create for replace the ojbect. Sometimes we are unable to do the create or replace because a program is running utilizing the object for someone us running a script or SQL statment utilizing the object. Is there a way to...
We have a custom migration system for Oracle Objects but it simply tries to create for replace the ojbect. Sometimes we are unable to do the create or replace because a program is running utilizing the object for someone us running a script or SQL statment utilizing the object. Is there a way to...
