Oracle Database Versions

Benefits of Oracle database 10g vs. 11g editions?

benefits of oracle 11 g edition over oracle 10 g express edition????

How do I import 10.2 dmp file into 9.2 database

I have an Oracle 10.2.0.2 dmp file from another site. I need to import the data into a 9.2.0.6 database on hp-ux 11.11. I cannot modify the xport file nor do I have a 10.2 database to import into, but I do have the 10.2 software. Is there any way to import the 10.2 dmp file into a 9.2 database? ...

media recovery

Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

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....

VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

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

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...

Difference between length and vsize functions

Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

Configuring isql *plus

Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik