Tag Info

New answers tagged

0

I see two options: 1) use DBMS_AQADM.ALTER_QUEUE to change the retention of the queue. This way, when you REMOVE a message, it still stays in the queue table with a status of PROCESSED. You can specify the retention period. The table remains fast even with these messages there. When you are done, you can either manually delete the rows or let the database ...


1

Do both servers have similar hardware and OS? Is there enough storage space for the 11g database? Have you thought about using data pump instead? With data pump and enterprise edition you can export and import in parallel as well as compress. With 10g you can compress the meta data but not the data. With 11g you can compress the data and meta data. How does ...


1

It could be that one of the imp default parameters for Oracle 10G is different in Oracle 11G. I would try adding the buffer=4096000 parameter to the imp command to see if that helps. That parameter is available on both exp and imp commands.


1

I see no reason you can't do this. Typically, you would perform the following steps. Move the *.dbf files found in %ORACLE_BASE%\oradata\ to a safe place. Move the files found in %ORACLE_BASE%\fast_recovery_area\ to a safe place. Move the spfile found in %ORACLE_HOME%\database\spfileXE.ora to a safe place. Install a new Oracle instance and Configure it ...


0

This seems to solve the question asked. Not sure if there is a solution without aggregating first: select lpad(' ',2*(level-1)) || child as result from ( select parent, max(child) as child from test_connect_by group by parent ) t start with parent is null connect by prior child = parent order by level ;



Top 50 recent answers are included