Dave44
Last Activity: Nov 13 '08, 08:21 PM
Joined: Feb 28 '07
Location: Calgary AB Canada
-
Did you install the 2 with the same user and group names? -
yep, within each schema look in user_tables or user_tab_column s. Or join the two on tablename and look for what you need.Leave a comment:
-
what kind of API are you referring to? a simple pl/sql function is technically an API. what is the underlying functionality behind the API you are putting together?Leave a comment:
-
when you truncate a table in oracle it removes all the allocated space from the table and puts it back into the free list. therefore the inserts need to go and request new space before it can insert. While i have seen this process slow things down some i wouldnt think that requesting enough space for 50K rows would take that long. what all is on the same I/O path that the datafiles you are using are on.
also using top to see that...Leave a comment:
-
well if your grouping by a "total" field then you have to sum up the fields you are dividing and then divide them. I must be misunderstandin g your question... it seems fairly straight forward.Leave a comment:
-
I think you need to post this over in a vbs forum. It doesnt seem that your getting your connection to the database set up properly.Leave a comment:
-
this is hard to reply to. You need to grab a book and get some of the fundamental PL/SQL syntax learned. variables need to be declared and if the scope of a variable is beyond the inner block then declare it in the outer block.Leave a comment:
-
I dont know if you can turn those off in sql plus.
Have you looked at using UTL_FILE to make your CSV?Leave a comment:
-
I agree with debasisdas, we use the same approach where i work too.Leave a comment:
-
could you use a case statement to substring the name and if its BCBS use the rest of the string to sort otherwise use the whole field? something like that?Leave a comment:
-
after each individual statement save the value of sql%rowcount in a UDV for later examination or use.Leave a comment:
-
for large deletes it can be faster to create a new table of the data you want to keep and rename it rather than deleting the old data.Leave a comment:
-
the tool cpuz will tell you all kinds of stuff about your systemLeave a comment:
-
also any failed attempts to insert will lose the grabbed sequence value. all the sequence truly guarentees is a unique value. several conditions can cause "skips" in the numbers.Leave a comment:
-
well for scheduling jobs oracle 10G and higher has dbms_scheduler, it has a lot of options for run times and resource usage management.
Im not sure what SSID is in sqlserver and so cant speak to the that.Leave a comment:
-
Just so i have this straight, for days 1 through 30 you will enter a certain number of hours and minutes, and then at the end of that 30 days you want to sum up all the hours and minutes?
If my assumption is correct you could just store the amount of time as a number of minutes for each day (eg. 10hrs:20mins = 620) and then just sum up the time on the 30th day and divide by 60 to get the number of hours and minutes in total.
...Leave a comment:
-
Give it an attempt first, i think you'll find this is pretty standard stuff. If you have trouble post your attempt here and we can point you in the right direction.Leave a comment:
-
oracle will make implicit conversions when it needs to but it will fall over if that conversion fails (as it should). Even for dates it will make an implicit conversion and if you luck out and have your default date format string match what you give then it will work.
In reality you should code your conversions EXPLICITLY, do not rely on oracle's attempt to convert it for you.
...Code:[125]SQL> SELECT *
Leave a comment:
-
If you install the oracle client you can then use Oracle's tool SQLPLUS. Oracle also has a free tool called SQL Developer (kinda like TOAD light), I havent used it on a Linux/Unix machine before though, only windows.Leave a comment:
-
If this is happening within the same oracle database then a DB Link is of no use here.
Objects such as tables are owned by the user they are created in. Did your "admin rights" user actually own the tables that you were using? If there was no prefixed schema name in front of the tables in your queries i will assume that yes that user did own the objects.
Now your new user cannot see those objects as it does...Leave a comment:
No activity results to display
Leave a comment: