- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- after insert commit completed but I cannot see dat...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 09:04 AM
тАО03-15-2003 09:04 AM
after insert commit completed but I cannot see data.
Insert Into
failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomCode,Series,TTF,Te
mp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So)
values('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1
,'1','0','0','0','368','','','R',sysDate ,'')
but after select I found no data
SQL> Insert Into
failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomC
ode,Series,TTF,Temp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So)
va
lues('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1
,'1','0','0','0','368',
'','','R',sysDate ,'');
1 row created.
SQL> commit;
Commit complete.
SQL> select sn from failure where sn = 'CAT0711023Y';
no rows selected
(some of insert was truncate here )
---------------------
I try troubleshooting what I found is:
1. rebuild all indexes , analyze table compute statistics , nothing corrupted.
2. if remove insert column "fixed" it will be able to insert.
( I mean after commit complete I can see data for those sn).
3. rename table failure to failure_a it will be able to insert.
4. if rename failure_a back to failure again it will not be able to see data
after insert.
5. no constraint related to failure table.
6. test with other sn got same result as above.
---------------------
I test this same query with another instance with same structure in this same
machine , it work fine.
--------------------
What wrong with my failure table.
thanks in advance,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 09:33 AM
тАО03-15-2003 09:33 AM
Re: after insert commit completed but I cannot see data.
do you have any "stored procedure" working upon "insert", and hence *doing* something with/to your data row?
FWIW,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 09:43 AM
тАО03-15-2003 09:43 AM
Re: after insert commit completed but I cannot see data.
thanks for fast response but
I have no store procedure.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 09:45 AM
тАО03-15-2003 09:45 AM
Re: after insert commit completed but I cannot see data.
could be a trigger.
select object_name, object_type
from user_objects;
this will show you all objects own by the owner of the objects.
post the output.
Other troubleshooting options will be to use SQLTRACE and TKPROF.
Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 08:08 PM
тАО03-15-2003 08:08 PM
Re: after insert commit completed but I cannot see data.
metalink did provide a dozen hits none of which meant anything to me.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 09:53 PM
тАО03-15-2003 09:53 PM
Re: after insert commit completed but I cannot see data.
I still doesn't get any clue from trigger/user_objects or rollback.
I just have simple structure database. no resource contention.
I cannot found similar problem in metalink.
Anyway I open a TAR but no response from Oracle for 48 Hrs.
I will update again if problem can be resolved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2003 11:53 PM
тАО03-15-2003 11:53 PM
Re: after insert commit completed but I cannot see data.
try the SQLTRACE option.
trace your sessions and you will get the solution.
if you need further help, let us know.
best regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2003 06:44 AM
тАО03-16-2003 06:44 AM
Re: after insert commit completed but I cannot see data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2003 06:49 AM
тАО03-16-2003 06:49 AM
Re: after insert commit completed but I cannot see data.
WHo know how can I delete my previous post ! it expost my password !!!
SO Stupid I am.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2003 07:14 AM
тАО03-16-2003 07:14 AM
Re: after insert commit completed but I cannot see data.
Thanks for help now my problem is solved by re-start database.
same insert statement work !
-----------
SQL> Insert Into failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomC
ode,Series,TTF,Temp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So) va
lues('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1 ,'1','0','0','0','368',
'','','R',sysdate ,'');
1 row created.
SQL> commit
2 ;
Commit complete.
SQL> select sn from failure where sn = 'CAT0711023Y';
SN
-------------------------
CAT0711023Y
------------------
This is strange , will see what Oracle will response.
But now my big problem is I post my db password ;-(