I'm trying to create a database dump of a remote 10G database. Using exp, I can get some of the objects, but the schema uses new 10G functionality that is not supported by exp (binary doubles...
Hi All,
I am trying to access sequence of a remote database using DBlink in Oracle.
( i want sequence.nextval)
Is this possible..?
if so, can anybody tell me the syntax for this...
I was looking at the syntax for logging in to RMAN and I am confused. Can someone clarify this for me. I want to use the catalog feature to store RMAN repository information in a database.
...
I accidently named a datafile NEWIMAGE_IMAGE05.URA instead of NEWIMAGE_IMAGE05.ORA
First question is, how can I rename this datafile without taking the tablespace off line.
The Second Q...
I have written an Oracle 8.1.5 application with an MS Access front end. The oracle database, through constraints and triggers, provides all of the data validation. I would like to try to cap...
ORA-01631 max # extents (505O reached in table ..xyz
Cause: A table tried to extend past MAXEXTENTS.
Action: If MAXEXTENTS is less than the system maximum, raise it. Otherwise, you mus...
TNSNAMES.ORA connection description :
Can anyone tell me the difference between the use of GLOBAL_DBNAME vs SERVICE_NAME and what to use when and why ?
Regards,
Ivan
What exactly is the ALL_OBJECTS.TIMESTAMP Column? According to the Oracle8i Reference, this character column is the "Timestamp for the specification of the object (character data)".
There...
Occasionally our weekly cold backup script fails due to receiving a 'shutdown: waiting for active calls to complete' message in the database's alert log (this situation occurs across a number ...
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 ...
How to check what grants a user has been given in the oracle schema?
Hi,
while migrating my database from MSSQL to ORACLE, i have to convert these DBCC statements to some oracle equivalent inbuilt functions...
DBCC DBREINDEX Rebuilds one or more indexes for...
O looking for a formula to convert pounds to kilograms and
inches to centimeters is there one out there?
I have a computer with Oracle 9i and 10g which works fine.
Now I have installed Oracle HTML DB with Oracle HTTP Server, and after installing these work fine.
However, when trying to acce...
Hi all,
I am looking to create two batch files to start and stop a database during a night so I can run a cold backup.
These batch file would be run by task manager at certain times.
...
In order to give a middle manager access to the OEM Tool does he have to have the DBA role to sign in to OEM?
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.
What's the command to show a table's primary and foreign keys using Sqlplus?
Hi,
Does anybody have any good way ( a script or something like that) to find out the list of one-off patches applied on an Oracle home. No doumentation or backup patch directories are kept u...
The listener to my database keeps shutting down. It might go for a day or 2 running just fine and then shuts down. It may also work for a couple of hours and then shut down. I have not foun...
I need to export a schema with all their objects. What command would I issue to do this?
How to fetch last 3 records from table in oracle without using rownum.rowid in a query?
Hello, I am planning to take my OCA/OCP certifications and have decided to study this on my own without going to a class. Can someone recommend a good book and also some good training videos f...
Hi all
I have the following program to make: i need to check the correctness of a view text (i.e. that it references the correct tables)
for this i need to get the view text, but it is a l...
I always use Universal Installer to check the installed components on my host.
Now I need to check which components versions are installed on a remote computer (no remote desktop) - is there...
