Re: Moving SYSTEM datafile

From: Jimmy Collins <jimmy_at_jcollins.de>
Date: Wed, 18 Dec 2002 00:11:40 +0100
Message-ID: <74bota.672.ln@10.1.1.1>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> schrieb im Newsbeitrag news:jzNL9.5188$jM5.15191_at_newsfeeds.bigpond.com...
> Er, 'tablespace' is an Oracle concept. Since you've just shutdown the
Oracle
> database, tablespaces cease to exist, and only datafiles are left behind.
>
> But I know what you meant.

ups - late @night... :-)

> > - startup nomount
> > - alter database move datafile ...
>
> Uh huh. Nope, I'm afraid there's no such command. As I pointed out
> elsewhere, the command is 'alter database rename file'.

...and later...

Regards
Jimmy Received on Tue Dec 17 2002 - 17:11:40 CST