sanjaykathuria
14th November 2003, 15:39
Dear/s all,

Earliar we were using two application server and one database server as three tier server technology. Now we have seprate one application server as test server and installed seprate database. But earliar both application server connected with database server. Same setup is working properly. Now i have installed oracle 8i database on one application server to make itself complete server. I have taken backup tool company without seprator from old database server.

When i am going to run bdbpost to upload tool company in seprate server message is coming as table cann't created (error 1959);


It's urgent


Sanjay Kathuria

Djie-En
14th November 2003, 17:35
Hi,

If it is Oracle Error 00959:
ORA-00959 tablespace 'string' does not exist
Cause: A statement specified the name of a tablespace that does not exist.
Action: Enter the name of an existing tablespace. For a list of tablespace names, query the data dictionary.

GN

NPRao
14th November 2003, 21:25
Also check $BSE/lib/ora/ora_storage_param for the proper schema names -

*:200:T:TABLESPACE lmsdata200a PCTFREE 5 INITRANS 3
*:200:I:TABLESPACE lmsindex200a PCTFREE 5 INITRANS 3
*:*:T:TABLESPACE DATA01 PCTFREE 5 INITRANS 3
*:*:I:TABLESPACE INDEX01 PCTFREE 5 INITRANS 3

sanjaykathuria
15th November 2003, 06:15
Done

Thax

Sanjay Kathuria