i can log on sqlplus useing : sqlplus “sys/oracle as sysdba” but on em log on: user : sys password : oracle give me error msg “invalid passowrd”
Answer Question | February 6, 2011 7:40 AM
Oracle 10g, Oracle 10g administration, Oracle error messages, SQL Plus
SET HEADING OFF; SELECT ‘Song Name: ‘, S.TITLE FROM SONG S I don want to display heading in the result table. I need result like: Song Name: Mungaru Male Song Name: Titanic Song Name: Milana But the Statement “SET HEADING OFF;” results in a result
Answer Question | November 24, 2010 6:07 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Query
Rename username in oracle 10g database without droping it
Answer Question | November 24, 2010 12:31 PM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle administration, Oracle User Profiles
I hava created a column like: create table pen(no integer, name varchar(30)) It contains the following data: NO NAME 1 reynolds 2 [...]
Answer Question | November 25, 2010 11:21 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration
wat is the difference between SYS and SYSTEM users in ORACLE?
Answer Question | November 23, 2010 7:39 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle User Profiles
In Oracle database- Assume that I have logged in as “jaga”(user name). can I use the user name “jaga” with the table name to refer a column. example : select jaga.emp.name from emp where age>100 here jaga is schema name(user name), emp is the table name and name is the column name. can i use [...]
Answer Question | November 22, 2010 12:24 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle Schema
I m using Oracle 10g Express Edition. when i type and execute the command COMMIT, I got the following error: “Commit statement not applicable. All statements are automatically committed.” please help me to get out of this.
Answer Question | November 22, 2010 10:35 AM
Oracle 10g, Oracle 10g error messages, Oracle 10g Express, Oracle error messages
I installed Oracle for Vista and when the enterprise manager screen came up I entered my username and password but it kept telling me it was incorrect. I closed out the web site, did a few things and came back. When I went to the Oracle Enterprise Manager again the page would not load and [...]
Answer Question | November 27, 2010 7:03 PM
Oracle 10g, Oracle 10g administration, Oracle Enterprise Edition, Oracle error messages, Windows Vista
I connected vb6 to oracle 10g using ADODC…can u tell me how to connect data reports using 10g?
Answer Question | November 18, 2010 7:28 PM
ADODC, Oracle 10g, Oracle 10g administration, VB 6.0, Visual Basic 6.0
Does anyone have experience of translating the german table/column names in a SAP /Oracle database
Answer Question | November 18, 2010 8:30 AM
Data translation, Oracle, Oracle 10g, Oracle Database, SAP, SAP Tables
Hi, I downloaded Oracle Database 10g Express Edition from Oracle site and i successfully installed in my system but while login i showed an error like “could not establish connection by network card” Please suggest me “how to install it”.
Answer Question | June 11, 2011 11:09 AM
Oracle 10g, Oracle Database 10g, Oracle Developer 10g Express Edition, Oracle installation
how to remove default window1 in 10g forms?
Answer Question | November 10, 2010 7:39 PM
Oracle, Oracle 10g, Oracle default parameters, Oracle Forms 10g
im new in oracle forms and i want to enter the industry number and when i press the retrieve button, name and surname must display, can you help.
Answer Question | November 9, 2010 8:49 AM
Oracle 10g, Oracle Data Access, Oracle Database, Oracle Database 10g, Oracle Forms 10g
I have two html files one is a template with certain data that must be transferred to the output file and the other file is also an html file which contains the most data that must be transferred to the same out put file. I have tried to write from both files to the output [...]
Answer Question | November 4, 2010 9:20 PM
Oracle 10g, Oracle 10g administration, Oracle PL/SQL, PL/SQL
hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage “run as administrator”. still [...]
Answer Question | November 8, 2010 7:12 AM
Database issues, Oracle 10g, Oracle 10g Database, Oracle Database, Windows 7
kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my application. 8) imp sys/XXX@XXX file=xx.dmp [...]
Answer Question | November 8, 2010 5:04 AM
EXP dump files, IMP, Memory dump files, Oracle 10g, Oracle 9i, Oracle 9i migration, Oracle upgrades, Windows Server 2003
i have a form c that operates a report report1 by using the following code: declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20); BEGIN repid := FIND_REPORT_OBJECT(‘REPORT1′); if :global.struc_code=51 then SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,’p_year=’||:yy||’ paramform=no’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘rep_app_oracle_forms’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘htmlcss’); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); WHILE rep_status in (‘RUNNING’,'OPENING_REPORT’,'ENQUEUED’) LOOP rep_status [...]
Answer Question | October 19, 2010 6:28 AM
Oracle 10g, Oracle 10g administration, Oracle Application Server, Oracle Forms 10g, Oracle Reports 10g
while i dumping one field in oracle i get result like this.. dump result : Typ=1 Len=7: 77,65,82,46,44,48,57 field : MAR.,09 so i try replace commond to avoid this ‘,’….then see dump for taht field again…. but still same dump result come…i dont know why??/please help me to solve this problem…
Answer Question | October 8, 2010 4:42 AM
Oracle 10g, Oracle Application Server
hello sir/mam i have a linux server loaded with oracle 10g with so many databses. i want other windows systems to access the databases of server through oracle 10g. could u please explain me in detail how to make this set up.
Answer Question | October 19, 2010 7:25 PM
Database connectivity, Linux, Linux servers, Oracle 10g, Remote connection, Windows connections
I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.
Answer Question | September 24, 2010 2:07 PM
Database frontend, Oracle, Oracle 10g, Oracle 10g Database, Oracle Database, Oracle Reports 10g