Re: Locally managed tablespaces and migrated rows

Execute Immediate is a wonderful thing, isn't it.

It gets very slow after the first thousand or so. I was doing one LM tablespace = one file of 128K, and making the file readonly immediately (to avoid checkpoint problems) and the rate of creation dropped to fewer than one every 10 seconds.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Howard J. Rogers wrote in message <3af951c9_at_news.iprimus.com.au>...


>

>Jonathan, I am desperate.... I need that script!!  I *want* 25,000

>tablespaces, but I'm buggered if I'm going to sit there typing the usual

 SQL


>out 25,000 times (besides, I get confused with my file names after the

 third


>one).  Email me, PLEASE!!!!

>

>(Just joking, though I've finally come up with a script that will insert a

>million rows into emp, which makes me happy.  God what a sad life I lead!)

>