OraFAQ Forum: Server Utilities » About Tablespce not found

Home » RDBMS Server » Server Utilities » About Tablespce not found

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About Tablespce not found [message #250115]

Sun, 08 July 2007 02:01

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.

Report message to a moderator

Re: About Tablespce not found [message #250119 is a reply to message #250115]

Sun, 08 July 2007 02:44

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: About Tablespce not found [message #250122 is a reply to message #250115]

Sun, 08 July 2007 03:32

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.

Report message to a moderator

Re: About Tablespce not found [message #250123 is a reply to message #250122]

Sun, 08 July 2007 03:43

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 20:16:46 CDT 2024