Exended table Space Problem

[Former Member]

Dear Team,

I extended my Table space in PRoduction server.

via Telnet I access my server then I extended my PSAPSR3 table space.

when I check via brtools default table sapce is

New file to be added (file) ........... [/oracle/PRD/sapdata5/sr3_33/sr3.data31]

Then Press 3 I Copy this path and just change sapprd2.

rest all is same.

Then I extended Table space .After extended table space.I check via BRtools that All file is extended only in oracle/PRD/sapdata5 not in oracle/PRD/sapdata2

If i see via brtools its show New file to be added (file) ........... [/oracle/PRD/sapdata2/sr3_33/sr3.data31]

I have added three file then check only folder name is changed i.e 31 ,32 and 33 But file name i.e sr3.data31 same in all folder.

drwxrwxrwx 2 oraprd dba 8192 Jun 21 17:22 sr3_33

sapprd1 :/oracle/PRD/sapdata5#cd sr3_30

sapprd1 :/oracle/PRD/sapdata5/sr3_30#ll

total 6291488

-rw-rw---- 1 oraprd dba 3221233664 Jun 21 17:39 sr3.data30

sapprd1 :/oracle/PRD/sapdata5/sr3_30#cd ..

sapprd1 :/oracle/PRD/sapdata5#cd sr3_31

sapprd1 :/oracle/PRD/sapdata5/sr3_31#ll

total 6291488

-rw-rw---- 1 oraprd dba 3221233664 Jun 21 17:28 sr3.data31

sapprd1 :/oracle/PRD/sapdata5/sr3_31#cd ..

sapprd1 :/oracle/PRD/sapdata5#cd sr3_33

sapprd1 :/oracle/PRD/sapdata5/sr3_33#ll

total 6291488

-rw-rw---- 1 oraprd dba 3221233664 Jun 21 17:28 sr3.data31

sapprd1 :/oracle/PRD/sapdata5/sr3_33#cd ..

sapprd1 :/oracle/PRD/sapdata5#cd sr3_32

sapprd1 :/oracle/PRD/sapdata5/sr3_32#ll

total 6291488

-rw-rw---- 1 oraprd dba 3221233664 Jun 21 17:28 sr3.data31

sapprd1 :/oracle/PRD/sapdata5/sr3_32#

whats the problem ? can I rename my datafile sr3_31 to sr3_32

What prerequest for this one . If I will not rename these file name . will it give any problem me in feature?

plesae suggest

kavi

[sunny_pahuja2 · Accepted solution]

Hi

>my PSAPSR3 table space.

> when I check via brtools default table sapce is

> New file to be added (file) ........... [/oracle/PRD/sapdata5/sr3_33/sr3.data31]

> Then Press 3 I Copy this path and just change sapprd2.

> rest all is same.

> Then I extended Table space .After extended table space.I check via BRtools that All file is extended only in oracle/PRD/sapdata5 not in oracle/PRD/sapdata2

What is sapprd2 ??

You cannot rename datafile...

You can do one thing...take tabespace offline and drop datafile..and add new one...

Also, please make sure that datafile should be empty..other wise database will be inconsistent...

Thanks

Sunny

[Former Member · Accepted solution]

Dear Sunny,

oracle/PRD/sapdata2 is another file system . I want to add in this file system. But I don,t know how It is added in oracle/PRD/sapdata5

How we can do tabespace offline and drop datafile ?.then how online ? plesae clear me ......

I think controlfile has been updated.

If I leave as is seeing here.Whats problem can i face in feature ?

Plesae cleare me?

thanks again

kavi

[sunny_pahuja2 · Accepted solution]

Hi,

If you have sufficient space in sapdata2 then i don't think there is any harm..

But if you specifically want to add in sapdata5 then, using brtools you can table space offline and drop datafile if it is empty...

But i will suggest don't do anything as datafiles are added in sapdata2 only... there is no harm in that..

Thanks

Sunny