• Oracle Statspack

    I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I'd turn is off at 5pm the next day. I did not turn it off and...

    Jwwolff10 pointsBadges:
  • run oracle 9i with Windows Server 2003 Domain Controller

    sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL....

    Swapnesh15 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Discoverer user assignment

    I have thirty+ new users i have to assign various reports to. What is the best way to handle this task? Is there a copy function so i can copy the existing user to the new user if they can access the same reports?

    QAQA65 pointsBadges:
  • Crystal Reports data

    I've written a report in CVrystal 8.5 that pulls the timestamp from an event table. A record in the event table is added each time a user logs into Oracle. I want to pull only the most recent record for each user and was wondering if there is an easy way to do that. Is there a MAX formula to get me...

    Jwwolff10 pointsBadges:
  • Oracle ERP single signon using Active Directory

    We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

    Morounfolu15 pointsBadges:
  • SQL Query

    Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08...

    Mariane10 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • can we install oracle10g client version and oracle 10g server on the same machine? will it work fine?

    can we install oracle10g client version and oracle 10g server on the same machine? will it work fine? If there will any problem so what will the problem? Please any one explain me. Thanks in advance. It's urgent please

    Rajesh00825 pointsBadges:
  • SQL select

    SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE --(UPPER(log.resolution(+)) like '%'||obj.object_name||'%' -- and trunc(log.resolution_date(+)) - trunc(to_date(substr(obj.last_ddl_time,1,11),'dd-mon-yy')) <=5 -- and trunc(log.resolution_date(+))...

    QAQA65 pointsBadges:
  • Oracle 10g Instance not starting Up

    Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

    Raj66615 pointsBadges:
  • Number precision

    What is the default precision of a variable declared as a datatype "NUMBER" in pl/sql

    Mahe10 pointsBadges:
  • use 32gb ram with oracle 10g and windows 32bits

    how can i use 32GB ram with windows 32bits and oracle 10g?

    Aztecmexico5 pointsBadges:
  • How to synch Lotus notes grop/contacts to my java application group/contacts ?

    Hi, I am new to lotus notes and wanted to synch lotus notes group/contacts to our application which is java. The requirement is we need a facility to copy/synch the lotus notes group details (including the group member contacts to the application ), that is a one way (from lotus notes to...

    AssimilatorHere5 pointsBadges:
  • oracle reports mailing labels

    I thought I had set the mailing label type in oracle reports in previous versions(6i) I can't find the option to do that now in version 9.0.4 (10g release 1). Does it exist

    Alisha25 pointsBadges:
  • Migration

    I like to migrate a database which is in IBM OS/400 V5R3MO (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration workbench will able to do so or...

    792755 pointsBadges:
  • “a program is trying to automatically send e-mail on your behalf” in D2k form

    whenever i send mail automatically throug D2K forms&Report I get a Message 'a program is trying to automatically send e-mail on your behalf'. i t will ask for a confirmation yes or no' it goes every time to the user. now if user will click on no then this mail will not go. so i want pl/sql coding...

    44063860 pointsBadges:
  • DB2/400 to Oracle 10g

    I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration...

    792755 pointsBadges:
  • Configuring a password message prompt on SQL Server 2000

    On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Pull all data (no of datas 7500) from Oracle at a time

    i am trying to pull all data (7500)form oracle but it gives me only 2313 data at a time.So how i can pull all data at a time ?

    ajitnarayan35 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