Re: Question for exam regarding multiple block sizes

None of the listed methods works.

A required first step is to specify a cache for the new block size - (after which you could do A and B)

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Belgium__November (EOUG event - "Troubleshooting")
____UK_______December (UKOUG conference - "CBO")


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Christian Hartmann" <cha_at_christian-hartmann.de> wrote in message
news:q1ptpvghllgblns6h4pv9r6udheggq09tr_at_4ax.com...


> Hi there,

>

> maybe someone can answer this exam-question regarding 9i:

>

> What are the two methods used to add a second, or subsequent, block

> size to an exisiting database? (choose two).)

>

> A. Create a new tablespaces and include a block size specification

> B. Transport a tablespace with a different block size into the

> database

> C. Re-Create the control file to specify a new block size for

specific


> data files

> D. Take a tablespace offline, and then put it back online with a new

> block size specification.

>

> I think it's A and B, my mate does not.

>

> May someone please clarify?

>

> Thank you in advance,

>

> Christian Hartmann