Managing Resumable Space Allocation ...

Use the following to setup resumable statements.

Alter session enable resumable; or Alter session enable resumable timeout <seconds> or Alter session enable resumable timeout <seconds> 'some descriptive name'

… run the sql …

Alter session disable resumable;

 

"This communication is confidential and may contain privileged and/or copyright material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email, delete the emails and destroy any hard copies. ANZ National Bank Limited does not guarantee the integrity of this communication, or that it is free from errors, viruses or interference."

Test blog ...

This is another test blog.

Sam Matthews
Senior Systems Engineer (Database)
Development and Build
ANZ National (NZ) Ltd
 
+64 4 494 4430 (x54430) – mon, fri
+64 4 496 7634 (x47634) – tue, wed, thr

 

"This communication is confidential and may contain privileged and/or copyright material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email, delete the emails and destroy any hard copies. ANZ National Bank Limited does not guarantee the integrity of this communication, or that it is free from errors, viruses or interference."

Certify - Certification Matrix: Oracle Database - Enterprise Edition on Solaris Operating System (SPARC)

Certify - Certification Matrix: Oracle Database - Enterprise Edition on Solaris Operating System (SPARC)

_____

Server Certifications

OS Product Certified With Version Status Addtl. Info. Components Other Install Issue

9 8.1.7 (8i) 64-bit N/A N/A Desupported Yes None N/A N/A
8 8.1.7 (8i) 64-bit N/A N/A Desupported Yes None N/A N/A
2.6 8.1.7 (8i) N/A N/A Desupported Yes None N/A N/A
9 8.1.7 (8i) N/A N/A Desupported Yes None N/A N/A
8 8.1.7 (8i) N/A N/A Desupported Yes None N/A N/A
7 8.1.7 (8i) N/A N/A Desupported Yes None N/A N/A
8 8.1.6 (8i) 64-bit N/A N/A Desupported Yes None N/A N/A
7 8.1.6 (8i) 64-bit N/A N/A Desupported Yes None N/A N/A
2.6 8.1.6 (8i) N/A N/A Desupported Yes None N/A N/A
8 8.1.6 (8i) N/A N/A Desupported Yes None N/A N/A
7 8.1.6 (8i) N/A N/A Desupported Yes None N/A N/A
7 8.1.5 (8i) 64-bit N/A N/A Desupported Yes None N/A N/A
2.6 8.1.5 (8i) N/A N/A Desupported Yes None N/A N/A
8 8.1.5 (8i) N/A N/A Desupported Yes None N/A N/A
7 8.1.5 (8i) N/A N/A Desupported Yes None N/A N/A

db character set

To find the character set that is being used.

SELECT value
FROM sys.props$
WHERE name = 'NLS_CHARACTERSET'

db character set

To find the character set that is being used.
SELECT value$
FROM sys.props$
WHERE name = 'NLS_CHARACTERSET'

Changing owner of discoverer reports

To change the ownership of reports in discoverer try the following.

1. Make sure noone is accessing discoverer.
2. Find the internal discoverer user id
3. run the following ...

update eul5_documents
set doc_eul_id = [new disco user id],
doc_created_by = [db user id],
doc_updated_by = [db user id]
where doc_eu_id [old disco user id]

4. verify by logging into discoverer and checking that ownership of reports has changed.

default attributes

This post is related to tablespaces with regard to partitioned indexes, but can be used with other storage attributes.

When creating local indexes make sure that an index tablespace is specified before you start specifying the individual partitions. For Example:


create index ... on ... tablespace ...
partition ... local ...


To change the default tablespace for an index partition then use the following.


alter index ... default attributes tablespace ...


note: When a local index is created as part of a new partition, then the tablespaces specified above will also be created.