Re: Help reqd - v.v.v.urgent

Hi,

>1} I have a batch file which runs the SQL LOADER which i run
> everyday. Now i'm planning to write a stored procedure
> which i would submit as a job to ORACLE which will fire it
> automatically everyday.
> The thought of HOST command struck me, but i don't know how
> do i use a HOST command in procedure. Is it possible to
> do so ?
> Is there any other way to accomplish this ?

If your database is running on Windows NT you can use the scheduler from Windows (technical service pack?).

>2} Suppose i have say 5 tables in my tablespace, i want to know how
> much space each table has consumed so far, how is it possible
> to see this?

select sum(bytes)
from dba_segments
where tablespace_name = 'DATA'
and object_name in ('table1','table2','table3','table4','table5');

>3} I am retrieving the max number + 1 from counter table for my
> current forms doc_id field. In a multiuser environment
> if 2 or more user's are working on the same form, then
> it'll allow only one fellow to save while others lose
> their data, in such circumstances what locking mode is
> to be used and why.

Make use of sequences. End of trouble.

>5} Can a foreign key reference two primary keys.

As far as I know, a foreign key can only refer to one table. And each table has only one primary key.

• Martin (mje_at_telebot.com)

  ---