create tablespace in standby database

[Former Member]

Dear Friends,

I created tapblespace in primary database

Now i need to apply archive logs in the standby server.

i followed the regular procedure while adding datafile in primaray server and next to standby server.

I given the command in standby server after mount standby database

SQL> alter database create tablespace PSAPEL700I extent management local autoall

ocate segment space management auto datafile '/oracle/PRD/sapdata9/el700i_1/el70

0i.data1' size 4096M autoextend off;

alter database create tablespace PSAPEL700I extent management local autoallocate

segment space management auto datafile '/oracle/PRD/sapdata9/el700i_1/el700i.da

ta1' size 4096M autoextend off

*

ERROR at line 1:

ORA-00900: invalid SQL statement

if this is not correct procedure

please clarify me how to create tablespace in standby database

Regards

Hari Kousik

[stefan_koehler · Accepted solution]

Hello Hari,

> i followed the regular procedure while adding datafile in primaray server and next to standby server.

No, you don't ... the exact procedure is described in the official documentation and your way looks completely different.

Please check this documentation:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10823/manage_ps.htm#1010429

Regards

Stefan

[Former Member · Accepted solution]

Hai Stefan,

Thanks sending link to me.its helped to me.

I just added datafile instandby server.after offlinelog applying in standby server,tablespace also created.

My issue is solved.

Thanks for your valuable suggestion.

Regards

Hari

[Former Member · Accepted solution]

Hai Stefan,

Thanks sending link to me.its helped to me.

I just added datafile instandby server.after offlinelog applying in standby server,tablespace also created.

My issue is solved.

Thanks for your valuable suggestion.

Regards

Hari

[peter_dzurov]

Please omit "alter database" statement. SQL command for creating TS should looks like this:

CREATE TABLESPACE tablespace_name DATAFILE Datafile_Options Storage_Options;

[Former Member]

Hai,

Thank you for giving answer for my problem

But this is standby server.i gave command

eg :

create tablespace PSAPEL700I extent management local autoallocate segment space management auto datafile '/oracle/PRD/sapdata9/el700i_1/el700i.data1' size 4096M autoextend off

its giving info database not open.

any other information about my problem.

pleae...

Regards,

Hari kousik