Thankyou Mike,
Sorry forgot to give details earlier. The exports were running fine till
yesterday.
The full database size is 400 MB, SUN SPARC 64 bit, Oracle 8.1.6
Thanks
Naushad
-----Original Message-----
From: Mike Ault [mailto:[Email Address Removed] Thursday, February 28, 2002 1:33 PM
To: 'Bhamani, Naushad A'; 'LazyDBA.com Discussion'
Subject: RE: Exports question
Space available and file size don't mean the same thing. On a 32 bit
platform youo may reach a 4 gig limit, with Oracle export the limit may be
as low as 2 gig depending on version.
Mike
-----Original Message-----
From: Bhamani, Naushad A [mailto:Naushad.[Email Address Removed] Thursday, February 28, 2002 1:26 PM
To: LazyDBA.com Discussion
Subject: RE: Exports question
Thanks Mike for your reply,
there is plenty of space.
Any other thoughts?
Please let me know
thanks
Naushad
-----Original Message-----
From: Michael Porter [mailto:[Email Address Removed] Thursday, February 28, 2002 1:23 PM
To: LazyDBA.com Discussion
Subject: Re: Exports question
Look at your export files size, you might be hitting an OS size limit. I
have seen this and it does NOT error out or complain about insufficient
disk space... Just a quick thought.
Mike
>>> "Bhamani, Naushad A" <Naushad.[Email Address Removed] 02/28/02 01:17PM
>>>
Hi Gurus,
Is there any limitation in export with regards to users. I am doing a
full
export and some how it gets hung at a particular user.
my export script looks like below
exp / file=${DUMP_DIR}/${DUMP_FILE} log=${LOG_DIR}/${LOG_FILE} full=y
compress=n consistent=y constraints=y direct=y grants=y indexes=y
rows=y
statistics=none triggers=y
Please let me know
thanks
Naushad
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page