• Migration Plan for 9i Linux to 10g Solaris

    Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g.

    MLC5 pointsBadges:
  • Support of TRU-64 UNIX and Oracle9i on any newly introduced Servers.

    I have RISC Based HP Alpha ES-45 Server with TRu-64 Unix and Oracle9i, I like to upgrade the server with latest high end server but I like to use the same OS and DB i.e. TRu-64 Unix and Oracle9. Is this possible in any newly introduced high end server.

    Gs5 pointsBadges:
  • Tablespace transporting back to older version of Oracle?

    Would anyone know if its possible to successfully transport a tablespace from Oracle 10gR2 back to a version in 9i? Thanks!

    Idooracle5 pointsBadges:
  • Oracle 9i how to create dictionary managed tablespace

    Hi, How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it? Thanks in advance.

    Pinki5 pointsBadges:
  • HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

    Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and be...

    IdongesitDaniel5 pointsBadges:
  • What is the best way to transfer data from an Oracle 9i database to a Lotus 6.5 database?

    What is the best way to transfer data from an Oracle 9i database to a Lotus 6.5 database?

    123456300 pointsBadges:
  • Trouble logging on to Oracle 10g database remotely

    This question was emailed to us I installed the oracle 10g (10.1.0) on a windows 2003 server where we already have Oracle 9i (9.2). I am able to login on the 10g DB from server but when I try to login remotely it gives the error ORA-12500: TNS:listener failed to start a dedicated server process....

    ITKE351,300 pointsBadges:
  • 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....

    Sukaina10 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • 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...

    Hunkgym5 pointsBadges:
  • 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...

    Basis50 pointsBadges:
  • HELP : I retrieve a blank page with UTL_HTTP in a request to a server which listen in a different Port than 80

    Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999,...

    Onacorpuscle0 pointsBadges:
  • 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

    Columbus0 pointsBadges:
  • 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

    Oraworld0 pointsBadges:
  • Oracle 9i Reports Developer

    I'm trying to open the Reports Builder 9i on my Windows XP Prof. SP1. The problem is that I can see the Reports Builder Start Screen and thats all. It always hangs at that point. I can open Oracle Forms Builder and everything else in the Developer Suite.

    Gboyd40 pointsBadges:
  • 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

    Oraworld0 pointsBadges:
  • Import utility in Oracle

    When importing a table (as a means of restoring), and specify ROWS = Y, does the data in the table get overridden?

    Mayleong0 pointsBadges:
  • Configuring OEM to access Oracle on 2 systems

    Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform--not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in...

    Mayleong0 pointsBadges:
  • Trying to solve ORA-00980: synonym translation is no longer valid

    I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...

    Aascotty0 pointsBadges:
  • time-based & change-based recovery

    i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now...

    Mayleong0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following