Search results for query: *

Hi, I am working on a database which potentially has a large number of tables. While I appreciate that Oracle theoretically supports an unlimited number of tables within a database, are there any known major impacts on performance or should I be looking to find ways to coalesce some of the data...

I have had a really strange thing and wonder whether anyone else has seen it where I have clicked "Reply To" in response to an email and it has generated a "Reply to All". Anyone else seen this?

I have a syb 11 db to look at tomorrow. I'd like to export a couple of the tables' contents to ascii for a trial upload to an Oracle db. What's the best way to do it? Help appreciated.

I had some fun and games last night in moving data between user functions which are arrays. There is no way of returning an array as a result of a function call. However you can use arrays by declaring your arrays as global at the top of your program; the values can then be accessed in any...

I have an interesting argument currently going with the production end of our database deployment team (my bit is the development side), and would be interested in opinions. I have a current process which runs once a day on a cron job. Fair enough, no real need for any DBMS_JOB here. But now I...

Anyone got any views on the new Sun Blades? I am seriously thinking about buying one and there's no-one in the UK to talk to about them as they aren't being released until next week over here.

I seem to have an interesting problem with AT and subprocesses. I have one AT command which calls a batch file which connects to a database and runs an Oracle script. This Oracle script generates a batch file based around the contents of what it finds in a few tables. At the end of my Oracle...

Here's an interesting problem; I have lost a considerable amount of hair recently with this one. I have a piece of dynamic SQL which does an ALTER TRIGGER xyz DISABLE (or ENABLE as the case may be). I can physically tell via DBMS_OUTPUT whether the triggers are firing or not, but I would like to...