Hi,
I am new to UNIX and I am more used to simple commands like those in VMS.
One of them is the ability to get the output from a job using the /out=<file> command in VMS.
I want to submit a job (a set of unix commands) using the AT command but to get the output in a file like that used in... (4 Replies)
Hi!
Can anyone tell me what went wrong in my shell script?
for dt_val in `cut -f 1 -d '|' /prod/ods/satyaki/sqlldr/grp.dat`
do
echo $dt_val
done
And, the output is -
23
39 (7 Replies)
I'm looking for a way in Korn shell to zero fill (or space fill) the output from df so that it will sort properly.
"Raw" output from df -k:
df -k
Filesystem kbytes used avail capacity Mounted on
/dev/vx/dsk/rootvol 4131866 3593302 497246 88% /
/proc ... (9 Replies)
Hi all,
I'm trying to generate a series of txt files starting from a plain csv file
part of my code:
#!/bin/ksh
INSTALLDIR=/Users/ME/Installdir
CSV=CSV.csv
TMP=/tmp/$(basename $0).txt
tr -s "\r" "\n" < /$INSTALLDIR/$CSV > $TMP
function Makefiles
{
printf '%24s:%30s\n' "sometext"... (1 Reply)
Hi,
I'm trying to copy the directories from one location(/tmp/source/) to other(/tmp/dest/).
for this I have written a PERL script.
snippet of code
$sourcePath = "/tmp/source";
$destPath = "/tmp/dest";
opendir(DIR, $sourcePath );
while($dir = readdir(DIR))
{
if($dir ne "." && $dir ne... (1 Reply)
FTP error:
ftp> dir */*/*/*.zip
227 Entering Passive Mode (10,58,132,123,204,83)
150 Here comes the directory listing
226 Transfer done (but failed to open directory)
And the machine where am getting the file(Client machine) has the below mentioned vsftpd.conf file.
Please let me know... (2 Replies)
I needed to view calendar for several months so I created a separate file for each and then pasted them like this:
cal Dec 2011 > x1;
cal Jan 2012 > x2;
paste x1 x2
December 2011 January 2012
Su Mo Tu We Th Fr Sa Su Mo Tu We Th Fr Sa
1 2 3 1 2 ... (4 Replies)
Hi Forum
Im making a script that takes multiple unix users and lists the users and the groups that the user is part of. the grouplist looks like this
grouplst="example_group1|example_group2|example_group3|example_group4"
I got most of it working but Im having trouble with a while loop... (4 Replies)
Trying to use mv in a shell script but for some reason this does not work:
for f in *.wav;do mv $f $f.bwf;done
I get this:
usage: mv source target
mv source ... directory
So it's like I'm using 'mv' wrong but I can't see how.
This works so the contens of the folder is read... (4 Replies)
Discussion started by: Oortone
4 Replies
LEARN ABOUT DEBIAN
drop_tablespace
DROP TABLESPACE(7) SQL Commands DROP TABLESPACE(7)NAME
DROP TABLESPACE - remove a tablespace
SYNOPSIS
DROP TABLESPACE [ IF EXISTS ] tablespacename
DESCRIPTION
DROP TABLESPACE removes a tablespace from the system.
A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be
dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are
using the tablespace. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to
temporary files residing in the tablespace.
PARAMETERS
IF EXISTS
Do not throw an error if the tablespace does not exist. A notice is issued in this case.
tablespacename
The name of a tablespace.
NOTES
DROP TABLESPACE cannot be executed inside a transaction block.
EXAMPLES
To remove tablespace mystuff from the system:
DROP TABLESPACE mystuff;
COMPATIBILITY
DROP TABLESPACE is a PostgreSQL extension.
SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], ALTER TABLESPACE [alter_tablespace(7)]
SQL - Language Statements 2010-05-14 DROP TABLESPACE(7)