Search results for query: *

I would like to use a trigger to copy each inserted row in a table named Test1 to a table Test1_Copy. Because of the following reasons I would like a simple trigger that would not reference each column: 1. the table contains many columns 2. I do not want to change the trigger each time I...

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

I want to move records from one database to another for archiving purposes. So I created a db link and a synonym on archiving server pointing to the production server like this: CREATE Public Database Link Prod_Link Connect to myuser IDENTIFIED BY "mypass" Using 'MyTnsName'; CREATE Public...

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...