Hi All,
As per my biz requirement, I need to drop the partition from our PROD table based on the retention period.
Hence I have written the script and called the drop partition procedure within the script.
The procedure is working fine and droped the partition from the table when I execute alone but when I call the procdure from the script itself, paritions are not dropped and throwing error. I really don't have any idea what is the reason for records are not dropped from the script.
Kindly provide your update on this.
Scriptname:drop_part_w56.sh
Error:
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 06-19-2017 at 05:03 AM..
Reason: Changed HTML to CODE tags.
in a xen environment , i see a lot op dropped packets via netstat -i
Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this?
I guess i have a xen issue of some sort,... (1 Reply)
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
All, I need to write an unix shell script which inserts some records into a file located in remote servers.
* Get the input from the user and insert according the first row. It should be in ascending order.
123451,XA,ABA
123452,XB,ABB
123453,XC,ABC
123455,XE,ABE
123456,XF,ABF
123458,XG,ABG... (2 Replies)
This is the mistake that i've done :
First of all go to /etc/apt/sources.list folder from terminal or using file manager ...
than copy the content of sources.list in to your adequate source.list.
Create a file named sources.list.bt and paste the same content
In the end open the... (0 Replies)
Fedora and openSUSE will replace MySQL with MariaDB:
Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet
The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Hi Friends,
I looking for the script for the count of the records in table.
and then it's containg the zero records then should get abort.
and should notify us through mail.
Can you please help me out in this area i am lacking. (5 Replies)
Hi,
I want to read multiple records from oracle database table and then based on each record I need to do some file modifications in UNIX.
I'm not sure how do I process each record from DB in UNIX.Below is the code snippet.
sqlplus user/pwd@DEV
for i IN (select * from table)
loop
-- for... (2 Replies)
Discussion started by: prats_7678
2 Replies
LEARN ABOUT HPUX
vparremove
vparremove(1M)vparremove(1M)NAME
vparremove - remove a virtual partition
SYNOPSIS
vp_name db_file]
DESCRIPTION
The command deletes a virtual partition previously created using the command. All resources associated with the virtual partition are made
available for allocation to other partitions.
Unintentional use of this command has serious consequences; therefore the user is prompted to confirm the operation unless the (force)
option is specified.
Options
recognizes the following command line options and arguments:
Specifies the unique name of the virtual partition which
is to be removed. Required.
Removes a virtual partition from the partition database
contained in db_file. If this option is omitted, the virtual partition is removed from the monitor's database. In this
case, the partition must be in the state to be removed. Thus it is an error to try to remove the current virtual partition,
the one in which the command is executing.
Specifies the force option.
Omits the confirmation dialog before removing the virtual partition. This option is intended for use by scripts and other
non-interactive applications.
SECURITY RESTRICTIONS
This command is restricted to processes owned by superuser.
When virtual partition flexible administrative capability is enabled, a virtual partition can only be removed from within a Designated-
Admin vPar.
RETURN VALUE
The command exits with one of the following values:
Successful completion.
One or more error conditions occurred.
EXAMPLES
Destroy the virtual partition in the partition database currently running in the monitor:
Destroy the virtual partition in the partition database currently running in the monitor using the force option:
Delete partition in partition database file
ERRORS
displays error messages on standard error for any of the following conditions:
o db_file does not exist, cannot be accessed, is not a virtual partition database file, or is corrupt.
o vp_name does not exist in the monitor's database or in db_file.
o vp_name in the monitor's database is in some state other than
o The command and the virtual partition monitor are at different revision levels.
o When the virtual partition flexible administrative capability is enabled and the local virtual partition is not a Designated-
Admin vPar.
AUTHOR
was developed by the Hewlett-Packard Company.
SEE ALSO vparadmin(1M), vparboot(1M), vparconfig(1M), vparcreate(1M), vpardump(1M), vparefiutil(1M), vparenv(1M), vparextract(1M), vparmodify(1M),
vparreloc(1M), vparreset(1M), vparstatus(1M), vparutil(1M), vparresources(5), vpartition(5), vpmon(5).
vparremove(1M)