Change tablespace in oracle dumps

Posted by eichelgartenweg on 3:32 PM with No comments
If you downloaded an oracle dump from Liferay's download site and want you want to import this dump into your Oracle-based Liferay DB you will receive several errors if your tablespace isnt "SYSTEM". To fix the tablespace just open the dump file (.dmp) with an text editor like Notepad++, UltraEdit or Wordpad. You will see some strange symbols. This is because no text editor can display the CLOB entries in the dump. Normal SQL-statements are visible.
So you just have to repleace the string "TABLESPACE "SYSTEM"" with "TABLESPACE "<your_tablespace>"".
The import now will complete without errors.