• OMS user name

    i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

    Sous580 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Size of temp tablespace in Oracle 9i

    We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question

    BrentSheets6,925 pointsBadges:
  • How can we pass Oracle username/password programmically?

    i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.

    Bina30 pointsBadges:
  • How can we call different canvases within one window?

    i want to design a form with three canvases. but problem is occur that other two canvases are not shown at run time. i want to create a push button and when i press it then 2nd canvas must be open.

    Bina30 pointsBadges:
  • Oracle stored procedure error with PL/SQL

    We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...

    BrentSheets6,925 pointsBadges:
  • Oracle archive log mode

    I have two databases A & B. A is a production database and B is an exact cloned copy of A and both are in archive log mode. I copy archived logs of database A using UNIX FTP binary mode to database server B and manually applied those logs to database B to keep both databases in sync. When I use...

    BrentSheets6,925 pointsBadges:
  • PSQuery storage

    hai,I am working on queries in peoplesoft.Ihad a dought that where these queries are stored in the database,means in which record this qry stored not the qryname,i need total query

    Kalyanisubbu5 pointsBadges:
  • form and report services

    i didnt install form and report services and it work good i dont have any problem work correctly(server,client...) why should i install it? and what about portal and wireless should i install it? why?

    Army125 pointsBadges:
  • Passing Parameters Between Stages within the Same Request Set

    I have a single request set which contains 2 stages. The first stage is the program extract which is a package. The second stage is a FTP job. I pass several parameters to the first stage. One of the parameters I would like to be a part of the file name the FTP stage creates. For example: I pass a...

    Petpat12370 pointsBadges:
  • form and report services

    it necessary to install form and report services from oracle application server

    Army125 pointsBadges:
  • Windows performance setting for Oracle

    We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram. The factors I'm looking at at the OS level is: - Paging: system...

    NormD5 pointsBadges:
  • store data from report10g to database

    how to use srw.get_page_num(...) and store the number in database

    Army125 pointsBadges:
  • SAP NetWeaver or Oracle Fusion for Java/J2EE background teckie

    Hi Andre I would like to update my skill from Java/J2ee(6 years experience) to Java Netweaver (administrator or Devloper ) or Oracle Fusion to explore market in US (mostly) and UK and work. I am confused between sap netweaver and oracle fusion due to certain factor that you would know for sure....

    Birenpg5 pointsBadges:
  • How user parameters are created in Oracle Reports 10g

    how user select the parameter from the parameter list and how it is created

    Nak7865 pointsBadges:
  • Oracle OMS – Please Help

    i'm expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data...)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn't...

    Sous580 pointsBadges:
  • Oracle 9i

    We had installed Oracle 9i and on AIX and then installed our front end application, now we want the oracle to have pro*c option. Is there any patch available to just install pro*c option rather than reinstalling oracle and selecting pro*c during installation. We cannot risk reinstalling oracle as...

    Nilesh197910 pointsBadges:
  • User Access to Oracle

    how to access Oracle ERP? Like SAP does oracle also has T-codes?

    Neh5 pointsBadges:
  • Error when using SQL*Plus @@ command in SQL Navigator

    When I try to use the @@ SQL*Plus command in a script I get the message "ORA-00936: missing exppression!" when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I've tried the same script in Oracle Enterprise Manager...

    Imre5 pointsBadges:
  • multi instances of the form and subform

    in order to create 40 different forms for my application, i created one form with subform with possibility to open many instances of it. However, the total in the subform isnt working in instances of the form but only on the original form. How to make the total on the subform work on every...

    Toli70 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