Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Posts
    3

    Unhappy Unanswered: Tablespace does not exists

    Hi.

    I'm trying to set a tablespace offline but i always get error
    'ORA-00959: tablespace does not exist' although the tablespace name is in the list. Also, the tablespace i'm trying to set offline is in the catalog table dba_tablespaces. How is this possible?

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: Tablespace does not exists

    Hi,

    It seems that Oracle doesn't check Default Tablespace user's.
    try to use this :

    select username, temporary_tablespace, default_tablespace
    from dba_users u
    where not exists (select 1 from dba_tablespaces t
    where t.tablespace_name = u.temporary_tablespace)
    or not exists (select 1 from dba_tablespaces t
    where t.tablespace_name = u.default_tablespace)
    order by u.username;

    Hope this help

  3. #3
    Join Date
    May 2003
    Posts
    3

    Re: Tablespace does not exists

    i tried the query you specified but the tablespace i'm trying to set offline was not on the list of temporary and default tablespaces of the its result.


    Originally posted by ndu35
    Hi,

    It seems that Oracle doesn't check Default Tablespace user's.
    try to use this :

    select username, temporary_tablespace, default_tablespace
    from dba_users u
    where not exists (select 1 from dba_tablespaces t
    where t.tablespace_name = u.temporary_tablespace)
    or not exists (select 1 from dba_tablespaces t
    where t.tablespace_name = u.default_tablespace)
    order by u.username;

    Hope this help

  4. #4
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: Tablespace does not exists

    Which tablespace is it ? (TEMP ROLL ...)
    if TEMP check this tablespace is not default temp of the user are using to take offline.

  5. #5
    Join Date
    May 2003
    Posts
    3

    Re: Tablespace does not exists

    it's one of the user's tablespaces and it's neither my default nor temporary tablespace.

    Originally posted by ndu35
    Which tablespace is it ? (TEMP ROLL ...)
    if TEMP check this tablespace is not default temp of the user are using to take offline.

  6. #6
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: Tablespace does not exists

    What is your tablespace name (as selected from dba_tablespaces).
    One possibility is that you have wrong case in the tablespace name. If it is the case, use exact tablespace name from dba_tablespaces (encased in double quotes).

    Hope it helps.


    Originally posted by tsdgas
    Hi.

    I'm trying to set a tablespace offline but i always get error
    'ORA-00959: tablespace does not exist' although the tablespace name is in the list. Also, the tablespace i'm trying to set offline is in the catalog table dba_tablespaces. How is this possible?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •