- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8.1.6 Table
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
тАО11-10-2004 04:33 AM
тАО11-10-2004 04:33 AM
Oracle 8.1.6 Table
I use Oracle 8.1.6
I created a (simple )table couple of days back and inserted 16000+ records into it.
Now i'm unable to access this table.
For eg..
Say, If i try anyone of the follwing sqlplus client would freeze and i had to kill it.
1) Select * from TEMP_REPORT_2004
2) Truncate table TEMP_REPORT_2004
3) drop table TEMP_REPORT_2004
4) Select * from TEMP_REPORT_2004 where 1=0
What could be the issue. ANy help ??
Attaching script i used to create the table for ref.
Thanks a lot
Raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 04:41 AM
тАО11-10-2004 04:41 AM
Re: Oracle 8.1.6 Table
To correct, you'd need to relieve the space problem and then deal with whatever the database is unhappy with.
Any messages in alert file
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
тАО11-10-2004 05:01 AM
тАО11-10-2004 05:01 AM
Re: Oracle 8.1.6 Table
Is client SQlplus on same machine and connect ok, this is just the query that hangs, please confirm
Can you run the following commands
1) desc TEMP_REPORT_2004
2) select * from TEMP_REPORT_2004 where rownum < 2
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 05:21 AM
тАО11-10-2004 05:21 AM
Re: Oracle 8.1.6 Table
probably you created the table as another user.
select owner from dba_tables where table_name='TEMP_REPORT_2004';
should reveal which user created this table.
Connect as this user and retry.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 05:38 AM
тАО11-10-2004 05:38 AM
Re: Oracle 8.1.6 Table
1) desc TEMP_REPORT_2004
2) select * from TEMP_REPORT_2004 where rownum < 2
1) Returns immdly with structure.
2) takes a while and coming back with results.
I'm using sqlplus client and server is in different location. Other queries runs fine.
Only this table gives me problem.
Steven,
i'm new to oracle.Can you tell me how to check whthr it reached last extent and no space left.
Thanks
Raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 05:39 AM
тАО11-10-2004 05:39 AM
Re: Oracle 8.1.6 Table
I only created this table. i again
double checked the owner and its me.
Thanks
Raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 06:00 AM
тАО11-10-2004 06:00 AM
Re: Oracle 8.1.6 Table
I found a way to check space on my table space .. its only 60.09% full.
I used script avbl in following link to check space details on my tablespace..
http://www.remote-dba.cc/oracle_tips_tablespace_full.htm
Thanks
Raj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 03:54 PM
тАО11-10-2004 03:54 PM
Re: Oracle 8.1.6 Table
maybe you had locked the table in a previous session.
try to run the following SQL statement:
select oracle_username, process, OS_USER_NAME, locked_mode from v$locked_object;
to get an indication of the locks (if any).
there could be also foreign key association between your tables....
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-10-2004 04:51 PM
тАО11-10-2004 04:51 PM
Re: Oracle 8.1.6 Table
I am going with the assumption that you haven't bounced the database yet. If you have, and you are still getting this error, then it is something more serious. I expect from what you have said is that this is a library cache lock on the table. From what I can tell, this is a lock on the header of the table, but doesn't show up anywhere else.
This is what you have to do. Login to one session of sqlplus, run a 'select distinct sid from v$mystat' to get your sid, then run a query that hangs against that table.
Then login to another sqlplus session (leaving the last one running) and run the following sql statement:
select a.username,a.sid,a.serial#,last_call_et,spid from v$session a, v$process b where
a.paddr = b.addr and saddr in
(select kgllkses from x$kgllk where kgllkreq = 0 and kgllkhdl in
(select kgllkhdl from x$kgllk where kgllkreq > 0 and kgllkses in
(select saddr from v$session where sid = &locksid)));
You will need to enter the sid from your session in the first sqlplus session. This will most likely give you a list of sid's and serial#'s that you need to kill. This should free up the lock, although it might take a few times.
As to the next question, why. I have no idea. I have never been able to reproduce the problem, and Oracle has said that it shouldn't happen, however what you are posting is similar to my experiances with the problem.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-11-2004 12:23 AM
тАО11-11-2004 12:23 AM