Happened to stumble by this on Metalink today, someone in serious need of a good shoeing (sp?)…
—
Subject: Re : Re : Creating temporary tablespace
The syntax is OK, for 8.1.6 at least (I never tried it on 8.1.5). I’ve used the following for the last several databases I’ve build, without any problems.
.
create temporary tablespace temp
tempfile ‘/blah/blah/temp01.dbf’ size 500M
extent management local uniform size 1M;
.
The thing to be aware of is that the file is created sparse on Unix platforms. Not a huge deal, generally, but you have to keep it in mind when looking at filesystem usage.
–
“I’m too sexy for my code.” – Awk Sed Fred
15-Aug-03 at 5:30 pm | Permalink
I have to admit my addled Friday brain has no idea what’s wrong with that (apart from the sig). No L337 SQL 5kiLL5 here.
18-Aug-03 at 11:14 am | Permalink
Yes, it’s just the signature I was laughing at. Sad fuck.
18-Aug-03 at 7:34 pm | Permalink
Ah. So the sig alone was enough to justify the post? Whatever you say : P
19-Aug-03 at 9:39 am | Permalink
Piss off, you cheeky cunt.
19-Aug-03 at 1:18 pm | Permalink
Hold on, I thought you were calling me a sad fuck. Never mind. Aren’t ASCII misunderstandings fun? : )
19-Aug-03 at 1:47 pm | Permalink
Nah, I was calling Awk Sed Fred the sad fuck, not you my good man ; )
ASCII misunderstandings are great fun, especially when they involve psychotic girlfriends…
20-Aug-03 at 3:58 pm | Permalink
ermm..
Vous les gars sont surtout drôles quand vous parlez dans anglais….