• How to solve lock problem in Oracle 9i on Linux

    Hi DBAs I have foundPersistent Lock in my database Suggest me how to solve this error.

    Murtujakhokhar0 pointsBadges:
  • Cannot connect to Database Oracle Error -1033.

    Hello, I have a Problem with my HP B132L-Workstation, running HP-UX 10.20 and Oracle 7.x. An application, which is based on the Oracle database won't start any more with the Error Message: Cannot connect to Database Oracle Error -1033. My first guess was, that the Harddisk is defective, or the...

    Pine140 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • Using Query returned values in Oracle Graphics 6i

    Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the...

    Mphani0 pointsBadges:
  • Indexing on Large table

    Hi, Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields. Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant. Suppose there are 2 attributes...

    Abhigreen10 pointsBadges:
  • Delete maximum records in a table

    Hi! I need to Delete maximum records in a table that has 2 columns, such as Ord No. & Part No. Each Part No. can have many Ord Nos. I need to identify the Maximum Ord No per part No & delete the record from the table. Help would be much appreciated! Sarj

    2908610 pointsBadges:
  • SQL Server 2005 adoption

    My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to...

    Nbellistri0 pointsBadges:
  • VB app connecting to Oracle database

    I have a custom VB application that connects to an Oracle database (9.2.0.5). It inserts records into an interface table then disconnects from Oracle. The VB app is on about 400 PCs with about 5000 inserts into the interface table daily. My question is having this app connect and disconnect so many...

    Skovac0 pointsBadges:
  • Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2

    I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I borrow a PC...

    Kfink040 pointsBadges:
  • Oracle 9i clone

    Hi I'm trying to clone my production db ona Sun box, NOT using RMAN. No problems with creating controlfile and dbf copies etc. I edit the controlfile create script and try to bring up the 'new' database and have a load of errors trying to recover the logfiles, even though startup without recovery....

    Latemorningperson0 pointsBadges:
  • Accessing Oracle database on Linux from Mainframe

    I want to read some data from Oracle 9i tables running on Linux machine. Can some ne help me as I am not very expert on mainframe systems Thanks.

    Singhbb0 pointsBadges:
  • SQL Query Perfomance Issue.

    Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my SQL query. I would...

    WasimAhmed0 pointsBadges:
  • installation of oracle8i

    i installed oracle8i in my system.when i put username:scott password:tiger It won't work i don't know what is the reason for it.so please tell me how to install or mount the oracle8i? Thank you saravanakumar

    Sarait0 pointsBadges:
  • Memory (helpfield) usage in Microsoft Access with VBA

    Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA...

    Gerhemmes0 pointsBadges:
  • Profile default values

    I understand how and why profiles are used. My question is; what are the default values for each resource. For example when a profile has the 'Connect Time' as 'Default' what is the value of the 'Connect Time'? I would like to know all the 'default' values for all the resources to properly set the...

    Redwine20 pointsBadges:
  • database down

    can anybody tell me how to know "Exactly at what time the database has gone down

    Madhavikota0 pointsBadges:
  • sql query

    what is the query to find which user is executing what sql statement

    Madhavikota0 pointsBadges:
  • sqlplus killed

    when i say SQLPLUS at $ prompt it is saying KILLED, hence i could not able to connect to my database. can anybody clear me how to connect to my database

    Madhavikota0 pointsBadges:
  • DB Replication with Oracle

    Hi, Is there any possibility to replicate data between an oracle DB and 500 clients with windows laptops: - bidirectional - asynchronous - with filtering on rowlevel - integrating an existing java based web application with Oracle; except for oracle lite? If no, anybody made experiences with other...

    Replication280 pointsBadges:
  • Effect of DB migration on Interfaces

    We are in the process of moving our R/3 4.6 system from Informix to DB2. What are the checks needed to ensure that the interfaces perform as expected. Thanks

    1018620 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