RE: [OFF TOPIC] RE: Question about LMT

2001-06-15 Thread Guy Hammond
I don't know if she has a web site, but this is one of her books: http://www.amazon.co.uk/exec/obidos/ASIN/0701168889/o/qid=992607058/sr=8 -1/202-3082814-8953423 I hear that her TV series will be coming on in the US soon. Her cooking style is very compatible with my own, full-fat ingredients

RE: [OFF TOPIC] RE: Question about LMT

2001-06-15 Thread Guy Hammond
Actually, this is a better URL: http://www.amazon.co.uk/exec/obidos/ASIN/0701172878/o/qid=992607528/sr=8 -1/202-3082814-8953423 g. -Original Message- Sent: 13 June 2001 20:01 To: Multiple recipients of list ORACLE-L Nigella I think I want to see this. And I know I want to know

Question about LMT

2001-06-13 Thread DEMANCHE Luc (Cetelem)
Title: Question about LMT Hi all, I created a tablespace in LMT. I created all my datafiles with an extra 64 Kb for the bitmap index. My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ? Example : datafile size = 500M + 64 Kb = 512064 Kb resize

RE: Question about LMT

2001-06-13 Thread Guy Hammond
Title: Question about LMT Hi Luc, If you try to resize a datafile to a size below that of the actual data it contains, Oracle will warn you. Try setting Autoextend on if you're worried about running out of space on a recently shrunk file; looking at your numbers I'm guessing that you

RE: Question about LMT

2001-06-13 Thread DEMANCHE Luc (Cetelem)
Title: Question about LMT Hi Guy, My question is only for the extra 64 Kb. When we created datafiles, we added 64 Kb for the last extend (becausebitmap index need only 64 Kb). Is it important to keep this extra 64 Kb when we want to resize the datafiles. Luc -Message d'origine

Re: Question about LMT

2001-06-13 Thread Igor Neyman
Title: Question about LMT Guy, I think 64K makes a difference, depending on the size of the uniform extent specified for LMT. Let say, we create 100M file with 10M extent size and don't add 64K to the size of the file. Then, the last 10M (minus 64K) in the file will be wasted. It does

RE: Question about LMT

2001-06-13 Thread Christopher Spence
Title: Question about LMT Also note, if you try resizing a datafile smaller than it has ever been, it will complain. In other words, if you have a 500M datafile and used 400M, then drop 300M,you cannot resize it to 100M. "Walking on water and developing software from a specific

RE: Question about LMT

2001-06-13 Thread Guy Hammond
Title: Question about LMT Luc, How are you calculating the size you want to resize the datafiles to? If it is based on how much they are actually used, then no. If it is based on an external calculation of how much space you expect to use, then yes, but 64k won't make much difference

RE: Question about LMT

2001-06-13 Thread Rachel Carmichael
Guy, Welcome back, we've missed you (and especially your Friday recipes!) Rachel From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Question about LMT Date: Wed, 13 Jun 2001 04:15:22 -0800 Hi Luc, If you

RE: Question about LMT

2001-06-13 Thread Guy Hammond
Title: Question about LMT Ah, got it, hadn't considered the extent size. Thanks, g. -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 15:36 To: Multiple recipients of list ORACLE-L Subject: Re: Question about LMT Guy, I

[OFF TOPIC] RE: Question about LMT

2001-06-13 Thread Guy Hammond
Hi Rachel, I kinda got sidetracked into being a system analyst for a bit, but now I'm a DBA again (at a different company). It's all coming back to me... then Oracle decided to go and release a whole 'nother version, 9i. I'll try to dig out a recipe for Friday. Incidentally, if anyone's

RE: Question about LMT

2001-06-13 Thread Christopher Spence
Title: Question about LMT i agree, I think the 64k is a mute point, at worse case you have one unusable extent at the end when using LMT. But if your extents are 100M, it may be a little issue. "Walking on water and developing software from a specification are easy if both are f

RE: Question about LMT

2001-06-13 Thread Deshpande, Kirti
:07 AM To: Multiple recipients of list ORACLE-L Subject: RE: Question about LMT Guy, Welcome back, we've missed you (and especially your Friday recipes!) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL

Re: [OFF TOPIC] RE: Question about LMT

2001-06-13 Thread Rachel Carmichael
Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: [OFF TOPIC] RE: Question about LMT Date: Wed, 13 Jun 2001 09:56:44 -0800 Hi Rachel, I kinda got sidetracked into being a system analyst for a bit, but now I'm a DBA again