Home » RDBMS Server » Server Utilities » export/import issue: character set
export/import issue: character set [message #71342] Fri, 18 October 2002 02:57 Go to next message
srikanth
Messages: 40
Registered: July 2001
Member
Hi,
I have a full dump of my database thro' exp command.I would like to move my database to some other location(i mean some other drive on the same m/c).But i couldn't achieve this since when i change the destination drive letter in the .dmp file,it gives an error "character set can't be handled".I thought this should be much easier than manually transferring the files.Could anyone help me out in this issue?

Is there any tool to modify the .dmp file to effect any modifications in the database.If yes,plz let me know soon.

Thanx in advance
Srikanth

Report message to a moderator

Re: export/import issue: character set [message #71343 is a reply to message #71342] Fri, 18 October 2002 04:03 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Build an empty database.
Recreate the tablespace to the new destination.
Then import the dump.

Report message to a moderator

Previous Topic: Running "Cat" scripts after DB creation
Next Topic: Re: OracleDBA
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 12:22:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.