Hi,
I have a windoes domain user which was defined on Oracle DB to have access: DOMAIN_X\USER_Y
DB alias = aaprod01
when i'm logined as this user (DOMAIN_X\USER_Y) on the client mechin...
I have just rebuilt an Oracle 9i database using UTF8 character set. I get the ora-03106 fatal two-task error when trying to connect with sqlplus 8.1.5 from a windows workstation. But I have an...
I have read the certification books about RMAN but it is not clear what are the signficant steps to creating a backup script using RMAN first in 8.1.7 and 9.2.0.4. I want to be able to fluentl...
Are the steps for recovering from loss of a system tablespace and controlfile different from other files or tablespaces.
tablespace recovery that I have is as follows:
4Recover Cur...
We have an Oracle 9.0.1.4 database on hpux 11i. What is the simplest or best way to restrict having regular clients accessing the database via tools such as TOAD, Excel, MS Access, ODBC etc. ...
I have been noticing this recently in my computer: Eventhough I'm not running any application or program related to ORACLE, oracle.exe gives me high number of memory and virtual memory size.
...
I want to analyze some tables in a schema that have not been analyzed in a few days. What is the quickest non time consuming method or command to analyze tables in a schema without consuming a...
Hi,
I have just inherited a number of Oracle packages that I need to maintain.
All the packages make reference to DBMS_REPCAT_INTERNAL_PACKAGE
I could not find any reference to this in t...
Hi ,
Restored an entire Oracle 9.0.1.4 database from tape . The database mounts but will not open and allow any login .
All the dbf files .. control files , logs were lost and recovered ...
Does Oracle Lite support the UNICODE UTF-16 character set that is implemented by default through the NVARCHAR2 in Oracle Enterprise 9i???
if i am running Oracle 9i, and i open the database with the command "ALTER DATABASE OPEN READ ONLY". How do i switch the database to "READ WRITE" without shutting it down first.
Thanks
Hi;
I want to create an export file from 10g database and import that file in 8.1.5 database. I know one solution, using 8.1.5 client I can generate a compatible export file from 10g database...
I am writing an app. in Delphi that interacts with Oracle. Part of my app. requires the ability to go to the OracleHomeDir\BIN and correctly locate valid client .dll names. There are soooooo m...
Using AUM on Oracle 9i
ORA-01555 Snapshot error during Export
Export is running approx 13 hours, then aborts with ORA-01555 error
The UNDO tablespace is at 2.5 G (already increased a few ti...
Hi -
I am using Discoverer4 and i am constantly receiving ORA-03123 'Operation Would Block'
Everything i have read (mostly from oracle) is that its not really an error and to try again. ...
Dear experts,
I got many but the same errors today at my Oracle Forms 6i and 9aAS server as follows:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Source: Application Popup
...
Hi
How (or what command do we use) to find out the number of bit for a
RHES Linux & Oracle 10g running in it?
if it's rpm, kindly give me the exact command with the options.
hello oracle masters,
i'm currently using oracle developer ver 6i. when i compile 'form1.fmb', it compiles with no errors.
problem:
when i exit out of the form, it gives me the follow...
I am trying to derive information this application we are working with which stores our reports in a LONG RAW field. I really need to just search for a text petterin within the column itself ...
exp cpamc1/cpamc1@dcpamdev parfile=/export/home/rscott/work/dcpam/build/cpts/data/../../cpam/data/ctllib/c91tbxxp.par file=ravi.txt log=ravi.log
Export: Release 9.2.0.6.0 - Production ...
Hi there everybody,
I am running a primary and a standby database both on 8.1.7.4, win2k server and on separate servers.
I have configured the standby database so it in managed recover ...
I have oracle 9i client installed on my windows 2000 server. I am trying to establish a data transfer from sql server to oracle server on another machine. So I modified the tnsnames.ora file b...
I followed the following instructions:
add the following lines to the end of the pfile:
############################
# Archive Log Destinations -sikyala(10/17/06)
####################...
Hello,
Here are some error messages I get following an attempted import ?
"ENTS 2 MAXEXTENTS 121) TABLESPACE "ROLLBACK_DATA""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illega...
i have lost oraInventary directory from /home/oracle.and now to to start OUI when i give ./runInstaller command then it says you have no permission for /home/oracle/oraInventory
I think i hav...
