At 400meg it shouldn't be a problem. If it is always at a specific user, is
there a problem with their data?
What does a dbverify run against the datafiles used by this user show?
Mike
-----Original Message-----
From: Bhamani, Naushad A [mailto:Naushad.[Email Address Removed] Thursday, February 28, 2002 1:34 PM
To: '[Email Address Removed] 'Bhamani, Naushad A'; 'LazyDBA.com Discussion'
Subject: RE: Exports question
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