cannot drop and alter datafile to tablespace.
Posted on 2004-10-06
My DB oracle V7.1
i have one tablespace cannot drop tablespace or alter add datafile to tablespace, it's show error ora-00959 "tablespace xxx does not exists" error show is same i key tablespace name
mismatch but i check tablespace name in view dba_tablespace
i not sure tablespace name it's keep upper case or lower case because i test in upper case and lower case it's not work.
for create this tablespace with upper or lower , i not sure
because have another create and he is not remember.
i want to known what is table keep actual tablespace name
, it's mean keep in lower case if have create in lower case.
how can i do this tablespace.
Thank you in advance.