Truncate data from a Materialized view

truncate table  

How to delete data from a Materialized View in Oracle

TRUNCATE TABLE

Informatica : initializing debugger...bind (wsaeaddrinuse)address already in use

click--->Tools-->ooptions-->click on Debug tab and below TCP/IP check pick a port number between Min and Max automatically
Min: 5001 Max:32000

eth0 not showing in CENTOS VM

1. Check whether the eth0 is available

                /sbin/ifconfig -a

            Please execute the aove script, if your result showing eth0 then please proceed to 2.
    
      2.    dhclient -v eth0
   
       This forces the interface to get an IP via DHCP

Then please check whether you can ping to outside world.


Also please check the below file.

/etc/sysconfig/network-scripts/ifcfg-eth0 and set

 ONBOOT=yes
 BOOTPROTO=dhcp

Extracting Numerical values from a string

1)  Cutting numerals from a string
        sed 's/[^0-9]*//g'
  
    For example:
                           Hello world my name is 1234abcd
        Output      : 1234



2)  Extracting First number from a string
        sed 's/[^0-9.]*\([0-9.]*\).*/\1/'
  
     For example: Hello 123 world, my name is 1234abcd
            output    : 123   
 

How to Read File names from a DIR in PERL

#Reading files from the Directory
my $dir = 'C:\Users\philip\Desktop\sample_files';
 opendir(DIR, $dir) or die $!;
 while (my $file = readdir(DIR)) {
        # Use a regular expression to ignore files beginning with a period
        next if ($file =~ m/^\./);
 print "$file\n";
    }
    closedir(DIR);

Dumping CSV files to SQL tables.

Select Import and Export data, by using this you can export any type of datas to your tables.

If you are using window authentication while accessing the tables then you should open this tool by the corresponding net user.

C:\Users\philip\Desktop>runas /netonly /user:DOMAIN\USERNAME "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe"
Enter the password for DOMAIN\USERNAME :