Oracle 10g Questions


Log on error Oracle enterprise manager
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
asked by:
10 pts.

Error with this Oracle 10g Express Edition query
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
asked by:
220 pts.

Rename username in Oracle 10g database
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
asked by:
50 pts.

Duplicate data in column in Oracle 10g Express Edition
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
asked by:
220 pts.

Difference between SYS and SYSTEM in Oracle 10g?
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
asked by:
220 pts.

User name and schema name in Oracle 10g
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
asked by:
220 pts.

Oracle 10g Express commit statement error
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
asked by:
220 pts.

Oracle Enterprise Manager for Vista
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
asked by:
5 pts.

Visual Basic 6.0 data reports with Oracle 10g
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
asked by:
Suk
5 pts.

Translating SAP Table names
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
asked by:
10 pts.

Oracle Database 10g Express Edition error while login
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
asked by:
220 pts.

Removing default window in Oracle Forms 10g
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
asked by:
15 pts.

Code to retrieve data in Oracle 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
asked by:
5 pts.

How can I generate an output file from two input files choosing data from each files using utl_file package or any other way?
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
asked by:
90 pts.

Oracle 10g database creation errors in windows 7
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
asked by:
15 pts.

Migrate Oracle 9i to Oracle 10g
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
asked by:
5 pts.

Can’t operate Oracle Reports 10g from a form called by another form on the application server
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
asked by:
65 pts.

Dump in oracle
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
asked by:
30 pts.

Connecting a database in a linux system from a windows system through oracle 10g
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
asked by:
15 pts.

Windows go blank while running reports in 10g
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
asked by:
5 pts.