Re: Automatic mailing

Hi Saroj

Task 1

1 Export the Tables. (Table Level Export) 2 Revoke quota on old Tablespace from user. 3 Make the New Tablespace the users default tablespace. 4 Quota unlimited on New Talespace to User. 5 Revoke Unlimited Tablespace from User 6 Import the Tables.
(This will import the tables to the new tablespace).

Or you could use the indexfile option.
1 Export Tables.
2 Import with the indexfile option.(indexfile=ddl.log) 3 Edit your indexfile script (ddl.log) and change the tablespace to the New Tablespace.
Alter user and change default tablespace to new tablespace. Quota unlimted on New Tablespace.
4 Run the ddl.log script to pre-create the tables into the new Tablespace.
5 Run your import without the indexfile option but with ignore=y. This will import all your data and create related objects.

Task 2

I am not very clear about the procedure for Windows NT but you could use the NT Schedular to execute batch jobs. This is similar to Unix cron.

HTH
Suhen

>>> Saroj.Dash_at_gecapital.com 10/26/00 12:05PM >>>

Hi,
Please help me the following task.
1.I want to move some tables in a new tablespace.So please tell me the steps
in detail.
2.I want to implement the hotbackup,coldbackup scripts are automatic in
windowsNT.Scripts are working fine.But after completin of backup i want to
send mail automatic to correspondin person.  

As it works in UNIX using crontab.In crontab automatic mail are sent after
completion of backup.

I want to do in Oracle version 8.0.4.
Similarly NT what is the features and how to implement. Please suggest me soon ,Bcos i want to implement in production database.
Regards,
Saroj.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: Saroj.Dash_at_gecapital.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).