have a problem.

i'm trying to create a table in oracle ver 7.3

but it says tablespace does not exist. when i add datafiles to any of the tablespaces it also says tablespace does not exist.

but i can see the tablespaces in dba_tablespaces.

its an old tablespace with several tables. i can access all of the tables in the tablespace(select,insert,etc)

this happened after we moved to a new unix machine. we could use the tablespaces before.

we copied all the contents of the old machine to the new machine.

we have another instance in the same server and it works fine. its just this other database thats giving us problems.


help!!!