Oracle 8i

data from oracle 10g to oracle 8i

Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object

how to come up with a backup and restore startegy for application developed on portal

we have an application that has been developed on oracle APP server 8i portal(forms and reports),Win2003 server(OS) is the a way I can create a backup plan and restore plan for the system which steps should i follow o ensure the successfull backed-up system thank in advance

how to install oracle 8i on windows 2003 os

how to install oracle 8i on windows 2003 os

step to install oracle 8i with client/server

i have installed oracle 8i in win xp prof. can i make it as oracler server or should i use win 2k. whar are changes in sqlnet.ora and tnsnames file. should i install d2k on client only. kindly reply me all steps for this instaqllation. thanks a lot in advance

My Oracle server is corrupt, and can't start using Oracle 8i

Hi, We have a database that is running oracle 8i on windows 2000 server, but unfortunately it seems corrupt. our intension maybe would be to re-install the database on another machine and migrat all the applications. please give us a guided approach to this problem, the database name DBCAB. Is it...

Is their any conflict between Oracle 8i and Windows 2003 Server

Whenever i insert oracle 8i cd, autorun starts and ends without any error or warning and i am unable to install oracle 8i on windows 2003 server. Same cd works on windows xp professional but not on server. Can anybody help me with this problem?

Oracle 8i to Oracle 10g Export /Import

Hi, Presently iam Exporting the Oracle Database of 8i version 8.1.6.0 on HP-UX to import on Oracle 10g 10.2.0.3 So my question is there is any need to apply 8i Patch before taking export i.e; from 8.1.6.0 to 8.1.7.4 this is the last & latest patch of 8i to support 10g so i want to ask you that it...

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import ? where as Oracle 10g has defaultly 8kb block size and Oracle 8i has 2kb Block size so it can import 8i database to 10g without any problem or we have to create additional 2kb block...

what is the difference between Oracle 8i and Oracle 9i

what is the difference between Oracle 8i and Oracle 9i

Database connection problem

I am working on a japanese project. the DB is oracle8i. So I am using classes102 and nls_charset10 driver zip files. I am able to connect to db through SQL* but not through code. the error is: java.sql.SQLException: 20 at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:407) at...

export oracle 8i database from unixserver

I have oracle 8i database on unixserver. How i able to export the entire database or schema to windows Xp. plz suggest

oracle installation in win98

When i install personal oracle8i, i got an error message oracle database could not start up it may be the problem of virtual memory .I reinstalled windows 98 and increased virtual memory but i got same problem.the oter thing is already it worked proprly and idon't no when the problem occured.Please...

Replication of Oracle 10g to 8i

Dear Sir, We are using Oracle 8i in our production and we have a plan to upgrade it to Oracle 10g. Lets say we have upgraded our production database to Oracle 10G and it is working fine for 1 day. After a day, lets say we found an show stopper issue which cannot be fixed in the near future. ...

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

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

Oracle Reference to Table_Name, Column_Name, etc by reference to variable

Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM...

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