OraFAQ Forum: Server Administration » Addition of datafile (merged 3)

Home » RDBMS Server » Server Administration » Addition of datafile (merged 3) (oracle 10g/Redhat Linux 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Addition of datafile (merged 3) [message #422215]

Tue, 15 September 2009 02:32

goracle9
Messages: 136
Registered: December 2006

Senior Member

i added a datafile to produsction today.

ALTER TABLESPACE "PARTS" ADD DATAFILE '/u03/oradata/cdb/parts02' SIZE 2000M AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED

this was my queary. i missed .dbf instead of parts02.dbf

how to include externtion to data file, i have physical standby database, what is the effect of standby

urgent pls. Embarassed

Report message to a moderator

Re: Addition of datafile [message #422228 is a reply to message #422215]

Tue, 15 September 2009 03:13

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

It's all in the very fine documentation.

Report message to a moderator

Re: Addition of datafile [message #422248 is a reply to message #422228]

Tue, 15 September 2009 04:44

goracle9
Messages: 136
Registered: December 2006

Senior Member

Thanks for replying, but there is no notes for missing .dbf

please let me know exact queary.

it may be like
alter tablespace PARTS offline narmal;

alter tablespace PARTS rename datafile
'/u03/oradata/cdb/parts02' to '/u03/oradata/cdb/parts02.dbf';

alter tablespace PARTS online;

Report message to a moderator

Re: Addition of datafile [message #422251 is a reply to message #422248]

Tue, 15 September 2009 04:48

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

but there is no notes for missing .dbf

Oracle does not care about "extension", it is just characters in the name.

Regards
Michel

Report message to a moderator

Re: Addition of datafile [message #422254 is a reply to message #422251]

Tue, 15 September 2009 04:52

goracle9
Messages: 136
Registered: December 2006

Senior Member

thanks Mr.Michel

anyway for uniformation of datafile as otherfile

could i rename as i said previous post?

is it exact queaty for that???

but this is production mind please.

Report message to a moderator

Re: Addition of datafile [message #422255 is a reply to message #422254]

Tue, 15 September 2009 05:00

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

The "exact query" is the four steps in the link under "Renaming Datafiles in a Single Tablespace"

But you have to do Step 2 also. Rename the datafile on the file system.

Report message to a moderator