I recently had a disk crash and was not able to clean the dump lv off the disk. Now trying to create new lvdump I am running into errors.
My question is how do I remove the old lv out of the ODM? I have tried going through smit and also just rmlv and it cannot find the lv. Yet when I run lslv on... (0 Replies)
I have a script which would monitor a given directory and delete any files which are older than 10 days. I was going to set the 10 crob jobs to perform this operation for 10 different directories (some are actually sub-directories), but my boss doesn't like that idea, so I need to do that in one... (1 Reply)
hi all,
i need to write a script. it should be able to clean the /etc/hosts file like this:
first field is the ip (what else ;))
second field is the fqdn (full qualified domain name)
third field is the hostname
the fourth to n'th field is the rest.
i hope you understand what is needed?... (5 Replies)
UNIX amature/novice. I've written a script (it works) that needs to be cleaned up. I'm searching for a way to perform a "go to , perform this then return" section of code. The books I have and searches i"ve done so far do not show me how to do this. I've pasted in the current code below. I've... (1 Reply)
When I run command:
>chdev -l hdisk1 -a pv=clear
It shows
Method error (/etc/methods/chgdisk):
0514-062 Cannot perform the requested function because the
specified device is busy.
run:
#>fuser -kxuc /dev/raw1
/dev/raw1:
How to clean PV id? (4 Replies)
Hello guys,
this script partially works but it's still pretty ugly and, moreover, if the month is jan/feb/mar... it doesn't work at all.
Could anyone say me how to correct, cut and clean a little bit?
#!/usr/bin/ksh
egrep -v -e "^\s*#" /file/permission | awk '{ print $1 }' | sort | uniq... (3 Replies)
Hi
I just want to clean up the space in UNIX. Is there any special command that does this process or do I need to manually type the following
rm <filename>
Any help would be really appreciated. Thanks (2 Replies)
Discussion started by: bobby1015
2 Replies
LEARN ABOUT REDHAT
drop_table
DROP TABLE(7) SQL Commands DROP TABLE(7)NAME
DROP TABLE - remove a table
SYNOPSIS
DROP TABLE name [, ...] [ CASCADE | RESTRICT ]
INPUTS
name The name (optionally schema-qualified) of an existing table to drop.
CASCADE
Automatically drop objects that depend on the table (such as views).
RESTRICT
Refuse to drop the table if there are any dependent objects. This is the default.
OUTPUTS
DROP TABLE
The message returned if the command completes successfully.
ERROR: table "name" does not exist
If the specified table does not exist in the database.
DESCRIPTION
DROP TABLE removes tables from the database. Only its owner may destroy a table. A table may be emptied of rows, but not destroyed, by
using DELETE.
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is
referenced by a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove the foreign-key constraint, not
the other table itself.)
NOTES
Refer to CREATE TABLE and ALTER TABLE for information on how to create or modify tables.
USAGE
To destroy two tables, films and distributors:
DROP TABLE films, distributors;
COMPATIBILITY
SQL92
SQL - Language Statements 2002-11-22 DROP TABLE(7)