Home » RDBMS Server » Server Utilities » About Tablespce not found
About Tablespce not found [message #250115] Sun, 08 July 2007 02:01 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I have created 10 tablespaces. And I imported data into these. After finishing imported I got error message because 'indx' tablespace was wrongly named with 'index' So, I used rename tablespace feature to rename 'index' as 'indx'It shows me successfully renamed. To be sure, I used
select tablespace_name from dba_tablespaces;

I saw indx tablespace is there. But whenever I use,
impdp sys/password directory=d tablespaces=indx


then the error comes ORA:39167 Tablespace name is not found.I am damn sure indx tablespace is present in my database.
Re: About Tablespce not found [message #250119 is a reply to message #250115] Sun, 08 July 2007 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am damn sure indx tablespace is present in my database.

But it is not present in the dump file.

ora-39167: Tablespace %s was not found.
 *Cause:  If exporting or importing over the network, the user specified a
          tablespace name that was not found in the source database.  For
          importing from files, the user specified a tablespace name not
          found in the dump file set.
 *Action: Retry the operation using the correct tablespace name.

Regards
Michel

Re: About Tablespce not found [message #250122 is a reply to message #250115] Sun, 08 July 2007 03:32 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel, in dump file it is present and I am also damn sure about it. I crosschecked about this one.
Re: About Tablespce not found [message #250123 is a reply to message #250122] Sun, 08 July 2007 03:43 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't see what you did.
I can't see what is in your file.
I can't see what is in your database.
The only thing I can see is the error message you posted and the meaning it has.

Regards
Michel
Previous Topic: Partitioning the table
Next Topic: Do we need to have a DBA privilege inorder to use IMP/EXP
Goto Forum:
  


Current Time: Thu Dec 08 14:50:00 CST 2016

Total time taken to generate the page: 0.06618 seconds