Recent content by jballum

Thanks for the input but that isn't possible. I found a workaround on the web which shows a BIG hole in windows. I created a local userid on the Server_A and another local user on Server_B (with same identifier and password). I granted the local userid on Server_A access to the file share. I...

No, the service is being started by a local user. It cannot be started by a user on the other domain (where the file share exists). Let me give an example: Server_A : file share opened to everyone is on this server and this server is on DOMAIN_A Server_B : service is on this server and this...

I am having an issue. I have some services/dcoms that when they are attempting to start they first access a file share to gather some info. The problem is that when the services are located on a server that is on a domain that is different from the server holding the file share the service...

Mufasa, Thanks for your detailed explanation with regards to redo-logs and rollback segments. Actually, what I was asking for was any suggestions for how to manipulate any Oracle processes (rollback / redo logs / storage) to speed things up temporarily to handle some maintenance that is going...

Thanks for the tips, they helped. Before: ~24 minutes (data and indexes exist) After Test 1 - all data but no indexes existed on the table (indexes were added after the conversion is run) - 8 minutes 30 seconds After Test 2 - no data or indexes existed on the table (data and indexes were...

Basically I am performing the following against a table with millions of rows in it and it is taking quite a long time. EXECUTE IMMEDIATE 'ALTER TABLE <tablename> MODIFY UPPER(column) NVARCHAR2(60)' Do you have any opinions of how to speed this process up? I am not sure how oracle is handling...

Never mind. I wasn't opening the file with unicode format flag set.

Does anybody have any suggestions on how to append rows of text to a file encoded in UNICODE format? I always seem to be outputting garbage characters. Thanx for any suggestions.

I just read an older posting on this topic and saw that the full BLOB is in fact stored in the redo logs. Does anybody have any suggestions on how to handle redo log space issues from a BLOB point of view?

If I have a field in a table of type BLOB and I update the record in some way will the full BLOB be saved n the redo log space? Thanx JB

Anybody know of a way to check for a specific service running on a server from another server via VBA? Thanx JB

Great! Thanx

I was given a full backup of a database and want to restore it. But I want to restore it with different logical file names then it was created with. Is this possible during a database restore? If not, any suggestions on the easiest way to recreate the existing one with different logical file...

Thanks Mufasa. That was going to be my workaround if there was nothing to directly insert into the schema2.table2

I have a .dmp with data from schema1.table1 (there is a create table statement as well). I need to import this .dmp file into an existing table called schema2.table2 (same fields as table data was exported from). I have tried using IMP with all sorts of parameter variances but I always seem to...