You’ve got a couple of issues here. Firstly, the different versions of Oracle you’re using is the reason for the table statistics error – I had the same issue when some of our Oracle 10g Databases got upgraded to Release 2, and some were still on Release 1 and I was swapping .DMP files between … Read more
impdp exports the DDL of a dmp backup to a file if you use the SQLFILE parameter. For example, put this into a text file impdp ‘/ as sysdba’ dumpfile=<your .dmp file> logfile=import_log.txt sqlfile=ddl_dump.txt Then check ddl_dump.txt for the tablespaces, users, and schemas in the backup. According to the documentation, this does not actually modify … Read more
How was the database exported? If it was exported using exp and a full schema was exported, then Create the user: create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>; Grant the rights: grant connect, create session, imp_full_database to <username>; Start the import with imp: imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y; If … Read more