Skip to Content
0
Former Member
Nov 28, 2009 at 09:38 AM

create tablespace in standby database

402 Views

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