Sponsored Content
Full Discussion: Truncate what is It?
Top Forums UNIX for Dummies Questions & Answers Truncate what is It? Post 41631 by google on Thursday 9th of October 2003 08:43:37 PM
Old 10-09-2003
not sure about progress databases but in Oracle, the truncate command is used to remove data from a table. Truncate is different from a delete in one important way, you cannot recover the data once the truncate command is submitted (you cannot rollback) but you can rollback your session after a delete (assuming you havent committed your changes).
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

truncate wtmp

I have AIX5.1 I have been trying to learn how to truncate the /var/adm/wtmp file. I have seen several things on google actually but don't quite understand. I also searched your forums but couldn't find it. one says this ">/var/adm/wtmp Is that all I do? I have a seperate question also. I was... (1 Reply)
Discussion started by: rocker40
1 Replies

2. Shell Programming and Scripting

How to truncate as filesize?

Hello everybody it's me again. I have a procces that is writing in a 'file1' automatically but i want to truncate 'file1' to a filesize 'x' that mean if the 'file1' size is 'x' i want to delete the first lines while the last lines are being writed, that have sence? in the process are an... (1 Reply)
Discussion started by: Lestat
1 Replies

3. Shell Programming and Scripting

Truncate File contain

I have one file which first line is blank and second line has some data. $cat filename output: 30-MAY-07 I want to store 30-MAY-07 value in one variable. for that I wrote var="`head -2 filename`" It will give that result but I want to truncate the first line which is blank. plz help. (2 Replies)
Discussion started by: rinku
2 Replies

4. UNIX for Advanced & Expert Users

*** Truncate certain field ***

I have a file in which I need to truncate 15th field to have only one character like Put --> P and if i have no value in 15th field, it should be "O" (Other) would really appreciate the reponses, thnx in advance:b: (2 Replies)
Discussion started by: sannmayaz
2 Replies

5. UNIX for Dummies Questions & Answers

How can i truncate filenmes?

I am using FC6 just in case it matters, though i hope it doesn't. If i have a file or some files that i want to truncate the filename of, so that it is only a certain number of characters in length, how would i do that on the command line? Also, just to make it more interesting, say i... (11 Replies)
Discussion started by: Calum
11 Replies

6. Shell Programming and Scripting

Truncate table

Hi In unix able to connect to oracle database and create table ,when rerun ,if table exist ,truncate that table.Any idea how to do that a.sh ---- sqlplus -s datadmin/password <<EOF create table xx(col1 number, col2... ); exit; EOF I... (1 Reply)
Discussion started by: mohan705
1 Replies

7. Shell Programming and Scripting

Truncate file name to 40 characters

Hello all. I would like to make a script (or two shell scripts) that will do the following. I need the maximum file name and directory name to be 38 characters long. As well, if shortening the file name ends up making all of the files in that directory have the same name, then I would like... (9 Replies)
Discussion started by: marcozd
9 Replies

8. Shell Programming and Scripting

Truncate string variable

Hi, I want to truncate a string variable, returned in the script. In perl I used the below and it worked. BRNo=BR12345 $BR = substr($BRNo, 2, 7) How can I do it in sh. Thanks ! (8 Replies)
Discussion started by: script2010
8 Replies

9. UNIX for Advanced & Expert Users

Truncate folder path

Hello, Given below are 2 sample paths from 2 different servers: /opt/temp/PROD/Script/New/Letters /opt/Share/temp/Share1/PROD/Script/Files/New/Letters I would like to truncate the path till the folder "PROD". Please note that the field count of the folder "PROD" vaires from... (1 Reply)
Discussion started by: DawnNish
1 Replies

10. UNIX for Dummies Questions & Answers

recover the truncate file

hi All, how to recover the truncate file in unix. Thanks!:wall: (2 Replies)
Discussion started by: krbala1985
2 Replies
vxevac(1M)																vxevac(1M)

NAME
vxevac - evacuate all volumes from a disk SYNOPSIS
/etc/vx/bin/vxevac [-g diskgroup] [-k [-O operation-tag]] [-t tasktag] medianame [new_medianame...] /etc/vx/bin/vxevac [-g diskgroup] [-O operation-tag] [-t tasktag] commit medianame /etc/vx/bin/vxevac [-g diskgroup] [-O operation-tag] [-t tasktag] rollback medianame DESCRIPTION
The vxevac utility moves subdisks off the specified Veritas Volume Manager (VxVM) disk (medianame) to the specified destination disks (new_medianame...). If no new_medianame arguments are specified, any non-volatile, non-reserved disks can be used as destination disks. Subdisks that are part of unmirrored striped plexes are moved by moving the entire plex to a new location. Note: This operation assumes that there is sufficient space in the disk group for the operation to complete. If the process runs out of space, some of the volumes on the disk may not be evacuated. vxevac is usually called from the vxdiskadm menus. A medianame argument is an administrative name used to define a disk within a disk group. The evacuation of a volume can be committed or rolled back if the -k option is specified. Such an operation is referred to as a "tentaive move." In addition, the -O option may be used to define a tag for a given tentative move operation. KEYWORDS
commit Completes tentative subdisk move operations by removing the source subdisks, and replacing them with the target subdisks. The -O option can be used to specify an operation tag for the subdisks whose tentative move is to be committed. If no operation tag is specified, the commit operation is applied to all completed tentative subdisk moves for the specified media. The commit opera- tion fails if a tentative move or a recovery resynchronization is in progress. rollback Reverses tentative subdisk move operations by removing the target subdisks, and leaving the source subdisks intact. The -O option can be used to specify an operation tag for the subdisks whose tentative move is to be rolled back. If no operation tag is specified, the rollback operation is applied to all completed tentative subdisk moves for the specified media. The rollback operation fails if a tentative move or a recovery resynchronization is in progress. OPTIONS
-g diskgroup Specifies the disk group for the operation, either by disk group ID or by disk group name. -k Initiates a subdisk move while preserving the source subdisks on the original plexes. The source and target subdisks are marked. The tentative move operation can be committed or rolled back at a later time. If the -O option is used to specify a tag, this tag can be used with the vxtask command to monitor, pause or abort such operations. -O operation-tag Specifies an operation tag that can be used to commit or roll back a completed tentative move operation. If an operation tag is specified, a task tag is automatically set to the same value. However, setting a task tag does not imply the setting of an opera- tion tag. -t tasktag Specifies an administrative operation to perform by the numeric identifier tasktag. See the vxtask(1M) manual page for informa- tion on Veritas Volume Manager tasks. SEE ALSO
vxassist(1M), vxdiskadm(1M), vxintro(1M), vxsd(1M), vxtask(1M) VxVM 5.0.31.1 24 Mar 2008 vxevac(1M)
All times are GMT -4. The time now is 08:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy