• 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:
  • Oracle express 6.3.4 web agent

    Hi, Im working with oracle expess 6.3.4 web agent and trying to create web pages to view data from 4 dbs using an application created by my collegue who has long left the company. I can view the data from 3 of the databases but when I added a fourth database i get a n error of "value nt in current...

    Caster1225 pointsBadges:
  • JD Edwards EnterpriseOne 8.12 Quality Management Module

    Hello-I have to develop a 1-day Core Team training class on the JDE E1 8.12 Quality Mgmt module. I want to be sure to educate users as to the pros and cons of this module's functionality. Any guidance on what to emphasize would be very helpful. Thank you!

    Chattie10 pointsBadges:
  • finding difference between two different rows of a column

    Hi aLL, I have a database running oracle 10g. I want to know if there is an oracle function that takes care of difference between two values in two different rows of thesame column. Thanks Soga

    Soga5 pointsBadges:
  • Oracle connection dropping out

    Oracle connection to the server is dropping down after 2, 3, 4hrs. no error's displayed, it will just close the window.

    Rcapuyan5 pointsBadges:
  • Future of ERP?

    What is the future of ERP, i.e. the so called next wave?

    Dpengster5 pointsBadges:
  • Purchasing Hazardous materials (Ora DB)

    Is there a real expert out there? Here you go: MRP Planners cannot validate “ESHM” for hazardous materials purchase requisitions. SAP does not allow the PR to route to QC or the buyer without this validation. Hazardous material must have an ESHM (Environmental/Safety/Health Management) number...

    Charlie615 pointsBadges:
  • 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. Now in...

    Arunilan15 pointsBadges:
  • saving text files in oracle database

    how to save text files in oracle database

    Venraas0 pointsBadges:
  • Oracle sys and system passwords

    I have a database that was created by a person who is no longer with the company. They changed the sys and system passwords but told no one. Is there a way to change (find) the sys and system passwords.

    Wynn5 pointsBadges:
  • Why numeric data truncated to be integer when declaring NUMBER data type in Oracle 10g

    Hello, My company recently upgraded Oracle server form 9i to 10g and I was requested to load all tables data from 9i to 10g. Most data transfer are good except this situation: If 9i table with date type declared as NUMBER, all numeric data will be truncated as integer in 10g (I used the same data...

    Sleu5 pointsBadges:
  • Recovering and restoring database

    I have taken a rman backup without controlfiles and i am not using recovery catalog i am uisng target database. NOw i lost all datafile s,controlfiles and redolog files.How do i get my databse up and running.

    Plmokn5 pointsBadges:
  • Oracle / EADH

    Can someone please explain to me what EADH (Enterprise Agent Data Hub) works?

    Tim B5 pointsBadges:
  • R2

    does anyone know if windows server R2 is compatible with exchange 2003?

    Wolfden0 pointsBadges:
  • Oracle Cross Schema View

    I am creating a cross schema view and am receiving the error 'Table or View does not exist' on the second table of one schema in my view. Here is the View: CREATE OR REPLACE VIEW WORKMGMT.VIEW_WORKMGMT_USERS( USER_ID, USER_VALID_FROM, USER_VALID_TO, DEFAULT_UNIT, LANGUAGE_PREFERENCE) AS SELECT...

    Ora mer20 pointsBadges:
  • Installer log

    what is an Installer log?

    Emx0 pointsBadges:
  • Problem Faced While Installing Oracle 9i on Linux

    Hello All, While Installing Oracle 9i (9.2.0.6) on Red Hat Linux AS4, I received the following error: - RPM to install the Legato Single Server Version (LSSV) product. Form more information, please refer to the Linux installation section in the LSSV Installation Guide at http://www.legato.com/LSSV...

    Champi0 pointsBadges:
  • Oracle table column names starting with a number

    Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to keep the...

    Jaime0 pointsBadges:
  • How to create a user login and password in Enterprised Manager in SQL server 2000

    Hello, I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000? Thanks,

    Tian81680 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