Search results for query: *

...locks) My first try was: CREATE TRIGGER Test1_Insert INSERT ON Test1 REFERENCING new as newRow FOR EACH ROW ( INSERT INTO Test1_Copy SELECT * FROM Test1 WHERE Id=newRow.Id ); But this get some locks and has unneeded overhead. Since I have all the data inserted with the newRow...

Why does the table IDL_UB1$ gets bigger every time i re-import the data. What I import does not contain PL/SQL at all.

I also added the following line in top of the sql script and run it using sql plus (to make sure that the whole process is a transaction): whenever sqlerror exit failure rollback

...FOR myuser.Docs@Prod_Link; I want to run the following sql statements on archiving server to move the records: INSERT INTO myuser.Docs SELECT * FROM DocsProd WHERE ID<1000000; DELETE FROM DocsProd WHERE ID<1000000; COMMIT; I have two questions: 1. Would it be faster to do it the other...

Thanks Mufasa for your answer. I understand what you mean. I just thought that Oracle EM Console was clever enough to report the space occupied by the dropped objects as free space.

I understand that after the import the system tablespace will get bigger. But after that I dropped all the imported schemas and the allocated space on system was almost the same as after the import. Shouldn't the additional space be released? Do you know what is the segment IDL_UB1$? The...

I made an import to specific schemas in an oracle db and the system tablespace got bigger. The three schemas that I imported had their own tablespaces. I do not know why but the system tablespace got bigger. I checked the dependencies of system tablespace and there were no user objects. I also...

Can anyone give more details about delivering an application like RemoteApp in Windows 2008 using Windows 2003. A previous thread mentions that can be done "using a remote desktop session that is locked down with group policy to just be the application they need. Essentially, the GP removes...

I need to connect to an Oracle 8i from Windows 7 64 bit. Oracle 11G ODBC does not connect to 8i Server. Oracle 8i ODBC does not install on Windows 7. I can not find Oracle 9i or 10G ODBC to try to install on Win7 x64. Any help?

When I start a shutdown of a guest Windows OS and I change to a different window other than vmware (before the guest has completely shut down), vmware is not exitting and stops responding. If I start the shutdown and wait for a few minutes then the Guest OS shutdowns normally and return to...

Is there a way to send email with Signature (using a certificate) from AIX Command line?

After a restore I made the following error occurs when trying to backup Logical Logs: Logbackup failed - Can't wait on current log; next log is not yet marked as backed up.

How can I add a new line character in a varchar variable in a stored procedure? e.g Define returnValue varchar(50); Define newLine char(2); Let newLine = ??? Let returnValue = 'Line1' || newLine || 'Line2';

I am using Tomcat 6 and any prints to stderr goes to stdout file. Stderr is defined in the startup application of tomcat and is created normally in logs directory but stays empty.

Can I find (or configure) a log file of all SQLs executed against an informix database?

I cloned my hdd with windows 2000 professional to a usb hard disk. Then I disabled the internal hard disk so that the usb hdd will be the first hard disk (so boot.ini will work ok). The system boots up from the USB but after a little time (before the GUI will show up) it crashes with the...

I copied files from one machine to the other and used netstat to see the active connections. It showed that only port 139 was used (netbios-ssn).

What ports are needed to be opened on a firewall to allow usage of windows xcopy command between two machines that are firewalled?

Does IDS 10 WORKGROUP edition supports RAW devices?

I want to import a text file (fixed column length) with lines of multiple formats. This file has one header line that has the number of records of each format. e.g Header line: 10 11 12 This header line says to us that follow 10 lines of format A, 11 lines of format B and 12 lines of format C...