How to Copy Data from a Table with a LONG Column into an Existing Table ======================================================================= Purpose: ======== The purpose of this article is to provide a working example of how to COPY data from a table with a LONG column into another existing table with the same structure definition. This document is especially useful…
/* file : 1 at_command_syntax */ at 00:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 09:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 12:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 15:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 18:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” at 21:00 /every:M,T,W,TH,F,S,SU “C:Pvmehsqlfilesftp01.bat” /* file : 2 my.cmd */ open ftp.pvmehta.com pvmehta nupur46 lcd C:pvmehdoc1Z0-030 put oracle_9i_upgrade_certification.htm close open ftp.pvmehta.com pvmehta nupur46 lcd c:websitepvmehtacgi-bin cd cgi-bin get PERLMYSQL.txt…
Real Application Cluster = OPS in previous oracle versions
Download for free from http://prdownloads.sourceforge.net/blat/Blat250.zip?use_mirror=voxel and installed using following command. Blat -installSMTP mail.pvmehta.com me@pvmehta.com After that i sent a text message using following command. F:UsefulBlat250Blat250full>blat – -body “test” -to me@pvmehta.com Blat v2.5.0 w/GSS encryption (build : Sep 14 2005 22:46:29) Sending stdin.txt to me@pvmehta.com Login name is me@pvmehta.com F:UsefulBlat250Blat250full>
select a.measured_date, a.total_users, a.active_users, b.user_cpu, b.system_cpu, b.idle_cpu, b.wait_cpu from stats$totalusers a, stats$vmstat2 b where a.measured_date = b.start_date and to_char(measured_date,’DD-MON-YY’)=’22-NOV-05′ and to_char(measured_date,’HH24′) > ’14’ and to_char(measured_date,’HH24′) < '19' order by measured_date desc Script that populates stats$vmstat2 table is dbblkabva01:/export/home/oracle/oraprocs/get_vmstat2.ksh ——– vmstats.ksh ————- #!/bin/ksh # First, we must set the environment . . . . ORACLE_SID=BLINKT export...
DBMS_UTILITY Oracle provides two procedures under the DBMS_UTILITY package related to statistics generation. (Oracle recommends use of DBMS_STATS package for generating statistics). DBMS_UTILITY.ANALYZE_SCHEMA This routine will generate statistics on an individual schema level. It is used for analyzing all tables, clusters and indexes. It takes the following parameters: schema – Name of the schema method…
10:17:18 SYS@WEBP:-> execute dbms_utility.analyze_schema(‘CS’, ‘COMPUTE’, NULL, NULL, NULL);
———————————————- Gathering statistics with DBMS_STATS ———————————————- DBMS_STATS.GATHER_TABLE_STATS DBMS_STATS.GATHER_TABLE_STATS gathers statistics for a table and its columns, and optionally the associated indexes. Call syntax dbms_stats.gather_table_stats(ownname, tabname, partname, estimate_percent, block_sample, method_opt, degree, granularity, cascade, stattab, statid, statown); The first two parameters are mandatory, the rest are defaulted to a value. ownname – owner tabname – table name…
create or replace package subs_cipher is function scramble ( obfs_in varchar2 ) return varchar2; — pragma not required as of 8.1.5 pragma restrict_references( scramble, wnds, wnps, wnps); function unscramble ( obfs_in varchar2 ) return varchar2; — pragma not required as of 8.1.5 pragma restrict_references( unscramble, wnds, rnds, wnps ); end; create or replace package body…
In the following statement, user hr on the remote database defines a fixed-user database link named local to the hr schema on the local database: CREATE DATABASE LINK local CONNECT TO hr IDENTIFIED BY hr USING ‘local’;
