Frequent ''ORA -1650: unable to extend rollback segment errors'' in the

2002-06-24 Thread Deepender . Gupta
Hi All,

1 Table and its Indexes occupying 30% space of the Database.

2002-05-13 Thread Deepender . Gupta
datafile for Index and data tablespace. I just want to know the precautions I need to take while maintaining this table. Is oracle 7.3 having restriction on the maximum size of the table. Kindly give your valuable suggestions. Thanks in advance, Deepender Gupta The New Power Company 1

Re: Unused users for the last 30 and 60 days.

2002-03-06 Thread Deepender . Gupta
Thanks John, I followed the steps told by you and It is really helpful to get the required output. Regds deepender

Unused users for the last 30 and 60 days.

2002-02-28 Thread Deepender . Gupta
Hi All, I want to have report of all the users who has not used their Oracle username for the last 30 and 60 days. Any views how can I get the report. Thanks, Deepender -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Se

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Deepender . Gupta
That's fine Rachel, > > I agree with you . But the problem is that when I do the import , import > goes fine till the first split file and it hangs only at a particular > position. I am doubting that when It switch from one split file to the > second split file it gives error. meaning which some

Re: Import from a dump which was split and compressed while export.

2002-02-27 Thread Deepender . Gupta
Hi Rachel, Thanks for the reply but can you explain "substitute the filenames you need for and the other files" I have tried with the cat file1 file2 file3 | zcat > /home/oracle/dkg/imp/imp_pipe & also. I think the log file name doesn't have any meaning. Regds deepender

Import from a dump which was split and compressed while export.

2002-02-27 Thread Deepender . Gupta
Hi All, The compressed dump export file size of my database is more than 2 gb and my OS file size limitation is 2 Gb so I compressed and split it into two parts while export. While export I got is "export terminated successfully without warning" but at the time of import,