If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Originally posted by SANJAY_G There is no way one can create segments in offline datafile, and I believe it is offline. Let's wait for his reply.

Hi Sanjay,

Here rohit has already added a datafile to the USERS tablespace and hence able to create the tables from the client.
What i find confusing is that, he is able to create tables from client connection but not from the server but why ??

Regards

Amar"There is a difference between knowing the path and walking the path."

Hi all ,
Thanks for all the replies. But i still dont understand the problem?
I want to expalin it again.
We copied a datafile called users01.dbf from a backup which was taken before resetlogs. This datafile was the only datafile in the Users tablespace. So we could not recover it and we do not have any other copy. So its obvious we were not able to browse any records of the users nor able ot create new tables. So we added a new datafile ot the existing tablespace without dropping the Tablespace and the corrupt datafile.
Now we have tow datafile users02.dbf and users01.dbf(Corrupted) in the tablespace users. We try to create tables from the system whihc has the database , it does not allow pointing to the error that users01.dbf is not accessible But to our surprise we were able to create tables from another machine . How we came ot know this was we craeted a recovery catalog for a system in this tablespace and all tables get created . We also tried creating a test table from anotehr client and it works , but tables are not getting created from the server. Its so confusing . Pls Do Advice.

Thanks

Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed

I don't believe it is possible to create a table from one place and not from another (server/client) - unless a different userid is being used, that has a setting of a different default tablespace that is available.