• 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:
  • Accessing OpenVMS Server.

    Can i use Hyperterminal to access the application on OpenVMS Server?The server has both USB and Serial ports.This particular server is running on ORACLE Database.

    Steven015 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:
  • RAC and Sun cluster

    We are installing 5 Sun Solaris servers (T2000's) for Oracle databases(no applications) in a RAC environment on EMC disk drives. The argument has come up as to whether using the Sun Cluster v3.2 is necessary when RAC is installed. One group states that the Sun Clustering complicates the...

    Chiqid0 pointsBadges:
  • 10 g Temp Tablespace always shows full in OEM.

    have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect.Every day I increase the size of temp tablespace.Night we run some procedures and morning temp tablespace shows Full.

    DAC15 pointsBadges:
  • Lotus Notes: TNS Could Not resolve Service Name

    Hi, I am supporting a lotus notes web application in LN 6.5.5. It has connectivity to Oracle for retrieving some details and display to end users. Off late, we are getting an error message intermittently and the error is "ORA-1254 TNS Could not resolve service name". Upon checking we found that...

    Cknishad15 pointsBadges:
  • Oracle Patch

    Oracle Patch p4898608_10203_GENERIC to AIX and p6079591_10203_AIX64-5L. I have already apply the patch p5337014_10203_AIX64-5L. Shall I follow the same procedure to apply the above 2 patches. I have not been given proper document to apply the above 2 patches by my previous people. Please advise....

    Subbiah5 pointsBadges:
  • oracle calculated item

    hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f...

    Rosealzubi115 pointsBadges:
  • Oracle froms n Reports installation error

    Hi All, I am trying to install oracle 10g form & Report on HP unix 11.11 I am getting following error. Starting Oracle Universal Installer ... Checking requirements... Checking operating system version: must be B.11.11 or B.11.00. Actual B.11.11 Passed All requirements met. Checking if CPU speed is...

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

    ITKE352,580 pointsBadges:
  • 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

    Smmd5 pointsBadges:
  • Oracle Report Printing Problem

    I am using Oracle Reports and Forms 6i with patch set 14 on WinXP, Ors 816 on 2000 Server. When printing to Zebra p520i Card Printer I get message: "Report Background Engine experiences problems and will close". Forms also hangs. However, my report prints successfully to my HP LaserJet printers....

    Moz5 pointsBadges:
  • username and password is asking oracle 10g database

    i installed oracle 10g dba clint side in my pc, but username, password and string is asking pls help me sir/madam

    Unix5 pointsBadges:
  • insert and updat remote table

    am using a trigger to sync a remote table every time there is an update or insert on the local table. The columns are user-type object. The tirgger can not insert or update on the remote table. I get the following error: CUSTOMERS Table : ORA-22804: remote operations not permitted on object tables...

    T-REX5 pointsBadges:
  • DBCA not opening

    Hi what could be the reason behind not opening the DBCA in Oracle 10g?

    Sr123470 pointsBadges:
  • BACKUP CONTROL FILE

    Is It ok to add the code of backup control file after each tablepace backup (in an online backup script?) or its should only be added into the last part of the online backup script? really appreciate any help

    Ceo20065 pointsBadges:
  • Limited capability and ability to change initial program

    We limited entering system level commands on our AS400 box by assigning initial JDE programs to user profiles. If they sign off from the applications (pressing F3 key), it kick them off from the session and gives them login screen. However we left limited capability set to *NO for all of them. Can...

    Nadavka5 pointsBadges:
  • Parameter file

    Hi I have installed Oracle 10g Win 2003 server, as I know there are 2 parameter files one is dynamic and other is static. how do I know that which parameter file is being used? If I go to EM DBcontrol "all Initialize parameter file" I can see SPFILE is disabled, means dynamic parameter file is not...

    Sr123470 pointsBadges:
  • Subtracting two Julian Dates

    I am very new to this position with limited knowledge. I would like to know how we can subtract two JULIAN dates in ORACLE. I have "ADMIT_DDT" and "DISCHARGE_DDT". Each of these dates consist of 10 digit number. I know first 5 numbers represent DATE and last five TIME. I would like to know to how...

    Tahirotahir5 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