Hi,
could you please explain me why it is unable to select data from SYS.ALL_TAB_PRIVS_RECD table from procedure:
Procedure code:
CREATE OR REPLACE PROCEDURE AtestProc IS
cnt number;
begin ...
http://www.experts-exchange.com/Database/Oracle/Q_23030312.html
I am getting this error periodically (most of the time, but sometimes it works).
ORA-01562: failed to extend rollback segment number 16
ORA-01650: unable to extend rollback segment R16 by 8 in...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23736042.html
Zones:
Oracle 9.xDate Answered: 10/07/2008 Grade: B Views: 23
Hello
As I wanted the datafile of the tablespace
(tbtest05.dbf) to point to another the datafile of admin tablespace (admin01.dbf ) ,I put the tablespace offline and renamed the datafile . ...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_20481785.html
How can I migrate my oracle 8 database to oracle 9i database.
What tool or procedure should I use to do so.
Tahir
http://www.experts-exchange.com/Database/Oracle/Q_20588243.html
Zones:
OracleDate Answered: 09/03/2004 Grade: A Views: 4
Still now I worked on Oracle 8.0. Right now i got an environment to work over the oracle 9i. Can you guide me some features about Oracle 9i and also oracle xml interfaces. You can suggest me either...
http://www.experts-exchange.com/Database/Oracle/Q_20599053.html
Zones:
OracleDate Answered: 09/07/2004 Grade: A Views: 5
Hello
I am a bit lost concerning the different ways of indexing on Oracle 9i. I am developing a data cartridge for text data and I don't know which index implementation I must choose. I red a lot ...
http://www.experts-exchange.com/Database/Oracle/Q_20614459.html
Zones:
OracleDate Answered: 05/13/2003 Grade: B Views: 0
Hi
I have submitted some jobs to the management server, however these are remaining as submitted and not proceeding to scheduled. According to the help this is because either the intelligent agent...
http://www.experts-exchange.com/Database/Oracle/Q_20783781.html
Performance issues after upgrading from 8.1.6 to 9.2.0.2. From monitoring some of the areas of performance degradation, it looks like the optimizer is not using indices where it looks like it shou...
http://www.experts-exchange.com/Database/Oracle/Q_20813911.html
Zones:
OracleDate Answered: 09/27/2004 Grade: A Views: 29
My business firm has up a very large database (VLDB) with
more than 60 million data sets in one database with 2 very
huge tables and other tables.
Is someone out there who have experiences with...
http://www.experts-exchange.com/Database/Oracle/Q_20856604.html
Zones:
OracleDate Answered: 09/04/2004 Grade: A Views: 0
Hi Experts,
Does anyone may rpovide me with a script or PL/SQL to make a cold backup for specific instance ? I would backup everything arhive logs if there are any and
anything else to be able ...
http://www.experts-exchange.com/Database/Oracle/Q_20889794.html
Zones:
OracleDate Answered: 02/18/2004 Grade: A Views: 0
