Re: Backup DB files to the Tape

2002-12-17 Thread dilmohan
Well for this you can use cpio command in Unix for copying files to Tape.

Another option is using ufsdump commnand .

Regards
Dilmohan

Ashraf Salaymeh wrote:

 Dear List,

 We have UnixWare 7.1 and I want to take backup of
 Database files (Physical files) to my tape.

 I did use tar command:

 tar c8v1 /home/oradata

 It's working properly but the problem is:

 tar can't handle large files(larger than 2GB).
 The total size of the DB files under /home/oradata
 more than 2GB.

 So the result I'll get some of those files not all.

 Could any body in the list give me the alternative
 command of tar that can handle backup of large files
 or any other solution...

 because I want to schedule this process.

 Your help will be appreciated.

 Regards,
 ashraf salaymeh
 System Analyst(OCP Certified DBA)

 __
 Do you Yahoo!?
 Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
 http://mailplus.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ashraf Salaymeh
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dilmohan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).




URGENT

2002-11-11 Thread dilmohan
Hi,
While trying to compile a procedure i face the error
PLS-00201 - sys.dbms_lock  must be declared

Which script do I need to run for this.

Regards

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dilmohan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).



Performance tuning

2002-11-06 Thread dilmohan

I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dilmohan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).