Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old November 27th, 2004, 05:08 PM
girl27 girl27 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 138 girl27 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 51 m 15 sec
Reputation Power: 5
Question data is loaded automatically??

Hi all,

Something wierd is happening. I was using sql loader to load some data to my db and things were working fine. Now everytime I logout and log in the tables have the data and even i deleted the data just before logging out? What could be happening?

And also i get this error when i tried loading my new data:

SQL-LOAD 951 Error calling once/load initialization
ORA 00604 error ocur at recursive SQL level 1
ORA 0054 resource busy and acquire with NOWAIT specified.

Before it happened this error but i just waited a little bit and then things were working now even i wait before i tried i still those error

Please any help would be really appreciate it.

Reply With Quote
  #2  
Old November 28th, 2004, 11:31 AM
beunique beunique is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Posts: 50 beunique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 4
Don't know!

To be honest - I have no idea

But have you tried to bounce the database? - this should clear any minor issues..(?)

Hopfully someone better then I will post a propper solution, but this would be my first approach.

Reply With Quote
  #3  
Old November 29th, 2004, 12:26 AM
girl27 girl27 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 138 girl27 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 51 m 15 sec
Reputation Power: 5
Quote:
Originally Posted by beunique
To be honest - I have no idea

But have you tried to bounce the database? - this should clear any minor issues..(?)

Hopfully someone better then I will post a propper solution, but this would be my first approach.



Hi, After a while it seemed to work . I did not get the data loaded automatically, to be honest too I dont know why this was happending yet. And now it seems that the server is down so I think it might be related to that too but who know.. now i should wait for the server to be up.

Thanks for your reply anymays.



Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > data is loaded automatically??


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT