Datafile rename?

[Former Member]

Hi,

While adding a new datafile to a tablespace using brtools, I mistakenly added <tspname>.data instead of <tspname>.data2 while copy/paste. I want to change it to the right naming convention.

How can I do it?

Thanks in advance.

Cyrus

[Former Member · Accepted solution]

Look at the note 868750:

http://service.sap.com/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=868750

[Former Member]

Dear Cyrus,

1:Connect to the database as SYSTEM.

2:Bring the tablespace offline:

sql>alter tablespace TOOLS offline;

3:Copy the datafile to the new location at the OS file system level:

!cp /ora006/oradata/FTWT29OR/tools.dbf \

/ora007/oradata/FTWT29OR/tools.dbf

4:Rename the datafile on Oracle:

sql>alter database

rename file '/ora006/oradata/FTWT29OR/tools.dbf'

to '/ora007/oradata/FTWT29OR/tools.dbf';

5:Bring the tablespace online:

sql>alter tablespace TOOLS online;

Note :Here I took example as tools tablespace.

Let me know the result.

Regards

Vinod

[Former Member]

Hi friendz,

what i will do when the swaps occured in the database.

regards

Raju

[Former Member]

Dear Raj,

Hopw its regarding memory ...

If ur issue is with swap you can add temporary swap space by creating a temporary swap file.

Let me know is this was ur concern.

Vinod