- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
|
Re:
High Water Mark.
could you please tell me what is high water mark in oracle terminology? Please explain with example.
|
|
|
Hi I just installed Oracle 11g R2 on my Win 7 Ultimate x86 machine in compatibility mode (XP SP3). It showed that the setup completed successfully (without a single error & warning, I got few when I ran it in Win 7 without compatibility mode enabled.). Now I am trying … 
|
|
|
Hello everyone, I have installed oracle 9i and iam unable to open sqlplus with scott and tiger. I tried many other usernames and passwords like system/manager, sys/sys as sysdba, sys/change_on_install but iam unable to login sqlplus. With scott/tiger, it is giving TNS protocal adapter error and with sys/sys as sysdba, … 
|
|
Re:
Accept/Prompt
Hi All, I am working in Oracle10g and I have been trying to run the following query, and am getting an error: [B]Query:[/B] [CODE=sql] SET VERIFY OFF VARIABLE emp_salary NUMBER ACCEPT empno PROMPT 'Please enter a valid employee number: ' SET AUTOPRINT ON DECLARE empno NUMBER(6):= &empno; BEGIN SELECT salary …
|
|
|
i hav just installed oracle 8i on my laptop but i am not able to open the sql plus what is the user name & password?? i hav tried scott &tiger but not working please reply soon
|
|
|
Re:
alter table
Hi Guys, I need some help. I don't understand how to do an alter table statement. I had a lab last week that used it and I couldn't get mine to work. [CODE]DROP TABLE ENROLLMENT CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE_SECTION CASCADE CONSTRAINTS PURGE; DROP TABLE COURSE CASCADE CONSTRAINTS PURGE; …
|
|
|
Hi all, Firstly- I've written a PL/SQl procedure to what I'm asking about in this posting. However, I'd like to do it with a single(or nested) SQL selection statement (I don't think its possible, but I'm no expert and was interested to hear if anyone has a solution- or just …
|
|
|
Please send me the working link of 'free downloading oracle9i' and steps for downloading it. Thank you!
|
|
|
How to create database in oracle. Is the tablespace and database same? Do we need to install client from oracle 9i? I have the code as follows Create Tablespace SCT_DATA Datafile 'sct_data.dat' size 10M online; and i come across the error as follows Create Tablespace SCT_DATA * ERROR at line …
|
|
|
Hi team, 1)There are 2 independent AIX platform available with 10g database running on it Mainly-Production and the other test machine 2)There is 2 tables which needs to be brought down from production to test machine I know expdp/impdp plays the key<commands as below-correct me if the below command needs …
|
|
|
Hi I have a new Dell Dimension 3100 PC running windows XP Home. I'm having difficulty with the microphone recording level in that it is so quiet you can hardly hear it. The sound drivers are from SigmaTel and are the latest version. I've checked all the sound levels through …
|
|
|
Hello friends, i m trying to input user : scott and pass : tiger also trying user : system pass : manager but even though its not going to start. i m getting following error [QUOTE]SQL*Plus: Release 3.3.4.0.0 ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: Enter password: ERROR: …
|
|
|
Hi I'm running Windows XP Pro. SP3. RDP used to work fine but following the SP3 patch (I think) I noticed that the RDP icon had changed in appearence. When I try and use Remote Desktop it launches and then displays an error box saying "Remote Desktop Connection has encountered …
|
|
|
Re:
files of tables
i have oracle 9i. my friend created some tables and inserted few records in each. I want these tables with the records inserted. which files should he send me and where should I place those files? will that affect my existing tables?
|
|
|
Hi, I am not able to logn in sqlplus.. while I can logon with the same username and password in Enterprise Manager... EM- username: sys password: ***** option as sysdba.. but with the same username and password i am not able to logon in sqlplus.. can anybody tell me the …
|
|
|
I have written my simple query using update and in a file with a .sql extension. However, I cant seem to update my table and yet at the end of the input it shows me 1 row updated I would also want to know how I can do 2 updates …
|
|
|
Re:
query in sql
hi, what is the diffrence between delete and truncate command in sql. plz send me tutorials of oracle also. waiting for your reply. <URL SNIPPED>
|
|
|
hi i am looking for a jiob as a junior Oracle DBA can any one please advice me on how to get an Oracle DBA job. i have beeen looking for where to startup my career but everywhere i go to they are asking for 3 or more years real-time …
|
|
|
Hi Guys I have designed reports in Discoverer Plus and the users are viewing the report using viewer. My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change …
|
|
|
hi, any help will be appreciated. I use Oracle discoverer plus. recently I tried to build a running total (average) calculation using the template provided. I defined 10 previous observations for this purpose. discoverer performed the calculation but the problem is with the first 9 (in this case) observations of …
|
|
Re:
import & export
Sorry for the simple question... But please i need help from you guys... How to import and export the database in oracle..iam have been using oracle 8i in my computer... im completely new to this environment... please help on this.. Thanks in advance... Shanti.
|
|
|
In oracle 9i ........How to delete duplicate entries in a table ? if suppose in a table named office, one or more entry(row) is repeated more then twice or minimum twice. I need a query to delete the multiple entries .... Note: --->No constraints applied on the table. --->No Primary …
|
|
|
|
|
|
First off, I'm not really a DBA... I'm learning as I go. The office I work in has a lot of problems when it comes to the integrity and reliability of data stored in our Oracle database. One of the little things I'm wanting to resolve is the duplication of …
|
|
|
Hi, I have a question pls clarify it. If a table is created and grant, index, triggers, synonyms etc are defined on the table. what happens to grant, index, triggers, synonyms etc if the table is dropped. What is the data dictionary needs to be checked to validate all these …
|
|
|
When I'm attempting to tnsping my database from the server it is stored on, I keep getting error code 3509, however I can ping my database from clients. I've checked naming in tnsnames.ora and all is as it should be. Any ideas???
|
|
Hi Guys... i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, …
|
|
|
Hi everyone I have one master table with the following structure incm_id Category SubCategory 1001 Expenses A 1002 Expenses B 1003 Income C 1004 Income D I have a child table where i am capturing amount value for the above table and structure is something like id fk_incm_id Amount 10001 …
|
|
|
hi, i am looking for a free download by oracle meant specifically for linux. i am using fedora core 5 32 bit version of linux. thanks.
|
|
|
Hi I'm the latest newbie to sign up here... I work in the IT industry and specialise in Oracle RDBMS software, installation, upgrades, health checks, tuning etc, you get the picture. Away from IT I'm into astronomy (got a 150mm reflector telescope) and I love playing chess. You will find … 
|