ORA 1410 "invalid ROWID"

Explanation:
This error is raised when an operation refers to a ROWID in a table
for which there is no such row.

The reference to a ROWID may be implicit from a WHERE CURRENT OF
clause or directly from a WHERE ROWID=... clause.

ORA 1410 indicates the ROWID is for a BLOCK that is not part of this
table. If you update a rowid where the BLOCK is valid but the slot
within the block is invalid you just get ZERO rows processed/returned.
This can be a source of confusion as it is inconsistent.

In my case , it is due to the index was rebuild at end of data (direct path) loading , while another select statement was running & caused the problem.

Solution:

Add dependency to the job for operational schedule.

VISTA on VMWARE network & sound problem

Install VISTA on VMWARE

main problems are network and sound, as driver is not automatically installed.

to fix network problem
1.Ensuer the network device type is vmxnet
2.Enable vmware tools in the menu. (the image file windows.iso should be under /usr/lib/vmware/isoimages/windows.iso). This should automatically mount the windows.iso as D: Drve
3.run the setup.exe from D: drive
4.If need manually update the drive. The location is D:\Program Files\VMWare tools\Drivers\vmxnet\win2k folder

To fix sound problem

Easy . After I add sound adapter in vmware console and logon to vista. I let it search on internet automatically . Done!


References:
http://www.brandonhutchinson.com/Installing_VMware_Tools_with_VMware_Player.html
http://h0bbel.p0ggel.org/installing-microsoft-vista-in-vmware
http://www.msfn.org/board/lofiversion/index.php/t52054.html

ORA-00600 [qmxtrScalarIsRewritable:dft] during expdp

Hit below two errors during running exp & expdp.

After increase shared pool size , the program gone.

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DBAM2
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DBAM2
About to export DBAM2's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [qmxtrScalarIsRewritable:dft], [], [], [], [], [], [], []
EXP-00000: Export terminated unsuccessfully



> cat expdp_DBAM2.log
;;;
Export: Release 10.2.0.2.0 - 64bit Production on Friday, 14 December, 2007 9:05: 54

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "LIQY"."EXPDP_DBAM2": parfile=exp_DBAM2.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.861 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-31693: Table data object "DBAM2"."M1_TM_COLLECTION_HISTORY" failed to load/u nload and is being skipped due to error:
ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","BEGIN S YS.KUPF$FILE.UPD_TDX...","parameters","kglpda")
. . exported "DBAM2"."M1_TM_FIN_TRANS_TRACKING" 888.1 MB 11968728 rows
. . exported "DBAM2"."M1_TM_LDL_SCT_DC_PAYMENT_UPD" 258.3 MB 2119285 rows
. . exported "DBAM2"."M1_TM_CONTACT_HISTORY_DONE" 715.0 MB 8097902 rows
. . exported "DBAM2"."M1_TM_SMS_ACTION" 100.0 MB 488877 rows
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "LIQY"."EXPDP_DBAM2" stopped due to fatal error at 09:08:59
ORA-39014: One or more workers have prematurely exited.