Database Administration (MOSC)

MOSC Banner

Error renaming datafile with embedded blank in the file name

edited Sep 19, 2013 5:41AM in Database Administration (MOSC) 6 commentsAnswered
Hello,

   One of our jr. dba's created a datafile in one of our databases (EE 11.2.0.3 on Linux RH).  The file was put in the wrong directory, so I want to move it, but she also created the datafile with an embedded blank in the file name.   I have taken the tablespace offline and am executing the following with the error returned below.  The /usr/orasys11.11.2.X/dbs and /oradata/PRDARCH1/data1 directory's definitely exist and oracle is the owner.

SQL> alter tablespace datamart_data_1m rename datafile '/usr/orasys11/11.2.X/dbs/DATAMART_DATA_1M _45.dbf' to '/oradata/PRDARCH1/data1/DATAMART_DATA_1M_45.dbf';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center