Guys I am investigating thid scenario.
Say I creating compressed rman backup sets and they are copied to tape. then a disaster occurs and i completly loose that server I now need to use these...
Hi!
I am administering the Oracle servers for a project since June 2007. I had only little previous experience.
Till now, I installed a developer and a test environment on two host mac...
Is there a significant difference between Oracle 10g Enterprise and Standard edition? If so, did each migrate from an Oracle 9 Enterprise and Standard edition repectively, or is Oracle 10g a ...
Seem to be getting intermittent errors while trying to connect to my Oracle 10g database, installed on my laptop. both server and the TOAD client GUI run on the same machine. I have tweaked th...
Hi,
I need to import/convert the provided XML file into Oracle 10g. I am looking for the most efficient means to accomplish this. Note I had to change the extension to .txt for upload pur...
cause: sga_max_size was increased to 2GB on a 32bit, 4G of memory win 2003 server.
I have tried to restart the oracle from the window services; created pfile from spfile and changed the mem...
Hi Experts.
Actualy I have an Oracle 10G database deployment that contemplate two boxes: A Primary and a Standby database. I'm having some troubles to manage when I need (could) delete the ...
Hi guys,
I am trying to use UTL_FILE in Oracle 10g to be able to read BLOB fields that store .PDF, .RTF, and .HTML data. Once retrieved, I want to be able to open them in their native prog...
I need a .bat script file that we can export the whole database (exp userid=system/system@db full=yes file=c:\TestFolder\test.dmp)
The backup user though should have only privileges to backup...
REP-52266: The in-process Reports Server repserver90 failed to start.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
i tried to change the rwnetwork.conf and changed it from...
"SELECT TO_CHAR(SYSTIMESTAMP, 'MM/DD/YYYY HH24:MI:SS.FF6') FROM DUAL" is returning 10/02/2007 14:30:49.646000. Why am I only getting milliseconds, when I'm asking for microseconds? This is O...
Need assistance with resolving "status blocked" message from listener for Oracle 10g database.
This is Oracle 10g on Windows 2003 server
Have tried ASM installed on different and same home...
What is the correct JDBC Thin URL for connecting to a Oracle RAC database with Failover
Is it this URL with LOAD_BALANCE=yes
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=T...
I need some quick help in writing the query. This should be strictly done in SQL and cannot be done in PL/SQL or cannot create sequence number (Only select access).
The query should be orde...
Hi guys
I have created an ER diagram based on the requirements given to me. Now I need to create these different tables in Oracle 10 g databse. The problem is I am new in writing ddl sql qu...
uname pwd error. Tried sqlplus "/ as sysdba' alter user scott ..it worked, with sql window only. But not when I am trying Database Control - orcl (which opens a webpage, asking Uname pwd). Pl...
Within the last month trc files in the Oracle bdump directory have been growing like crazy. Each of them bear a size ranging from 3 Mb to 100 MB and everyday they seem to be taking up 800 mb t...
I would like to get a Script that I could load on to my Sun Solaris (9)Server. This script should, upon startup of the Sun Server, should automatically start the Oracle Database located on tha...
I am trying to connect to a oracle 10 database through a webservice call. I get a TNS error shown below
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapExcep...
How can I connect, using SQL Plus, to a specific database.
Eg in DB2 one can perform the following command, once at the DB2 prompt
connect to <database_name> user <user_name> using <passwo...
Hi,
I See the data in the databas table (From Toad) as follows.
--------------------------------------------------------Discount table data diplays as follows.
CUSTOMER_NO TRANSACTION_ID ...
C:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.
C:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole india
Enviro...
Hi ,
I'm using oracle database 10g 32-bit windows edition in my environment and I want to migrate to 64-bit windows edition , is there any step by step walkthru which I can use for this upgra...
With Oracle 10g R2 installed on Windows 2003 Server, when I try to start the listener, DOS tells me that the ORACLE_HOME is not set. How do I set the ORACLE_HOME and ORACLE_BASE on a Windows ...
hi i have a csv file and is it possible to save it as a dat file?i want to use this file to uplaod data to oracle
i couldnt decide which file type to select when i did file save as...
