exec_query=`sqlplus -s "$login/$passwd@$db"<<EOF
DROP TABLE IF EXISITS $table1;
CREATE TABLE $table1 AS \
SELECT * FROM $login.$table \
WHERE $i IN \
(SELECT $i FROM $login.$table \
MINUS \
SELECT $i FROM $login1.$table);
exit
EOF`
done
I thought that the maybe my query is too long to put it in one line. I decided to split it - just like above. It is working fine now.
Hi all,
I have to create table for each month inside a perl script.
tablename_monthnameyear.
megh_aug2008 for august 2008.
megh_sep2008 for september 2008.
just like the logfiles created on date basis.
thanks
megh (1 Reply)
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Hi guys as the title says i need a little help i have partisally written a bash script to create a table in html
so if i use ./test 3,3
i get the following output
for the third arguement in the script i wish to include content that will be replace the A characters in the... (2 Replies)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Hello Frens,
I am a newbie to shell scripting. I need a help on creating a for loop script (shell script) for removing files. I have a table called a_table with column name fil_name which contains all the files that need to be removed.
Thank you in advance (6 Replies)
Discussion started by: manisha_singh
6 Replies
LEARN ABOUT V7
pwck
pwck(1M) System Administration Commands pwck(1M)NAME
pwck, grpck - password/group file checkers
SYNOPSIS
/usr/sbin/pwck [filename]
/usr/sbin/grpck [filename]
DESCRIPTION
pwck scans the password file and notes any inconsistencies. The checks include validation of the number of fields, login name, user ID,
group ID, and whether the login directory and the program-to-use-as-shell exist. The default password file is /etc/passwd.
grpck verifies all entries in the group file. This verification includes a check of the number of fields, group name, group ID, whether any
login names belong to more than NGROUPS_MAX groups, and that all login names appear in the password file. The default group file is
/etc/group.
All messages regarding inconsistent entries are placed on the stderr stream.
FILES
/etc/group
/etc/passwd
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO getpwent(3C), group(4), passwd(4), attributes(5)DIAGNOSTICS
Group entries in /etc/group with no login names are flagged.
Group file 'filename' is empty
The /etc/passwd or /etc/group file is an empty file.
cannot open file filename: No such file or directory
The /etc/passwd or /etc/group file does not exist.
NOTES
If no filename argument is given, grpck checks the local group file, /etc/group, and also makes sure that all login names encountered in
the checked group file are known to the system getpwent(3C) routine. This means that the login names may be supplied by a network name
service.
SunOS 5.10 20 Oct 2002 pwck(1M)