Can you time how long an Oracle import takes

importoracle

I'm on a Windows machine with Oracle Client 11.1.0, and am going to import a database dump. I'm importing from the command line with the "imp" command.

Is there an option to time how long the import takes? I've searched around but haven't found anything for that yet.

Thanks in advance!

Best Answer

If you just want to time how long it takes, you could call it via a batch file like this:


echo %DATE% %TIME% >> time.log
imp parfile=./file.par etc etc
echo %DATE% %TIME% >> time.log

Once everything has run through, have a look at the time.log file and work out the difference between the 2 values.

Related Solutions

Oracle imp crashes without error

Maybe an error appears in the target database's alert log? Run this:
```
SQL> show parameter background_dump_dest
```
...and go to the directory given to check the alert_<SID>.log. Or do a trace of the imp session in the target database instance. (Usually the errors appear in the exp / imp output themselves (saved to a log with LOG=log_file.log ) but I assume the export ran file with no warnings and completes with):
```
"Export terminated successfully without warnings."
```
When you are copying the file, are you sure it's not getting corrupted somehow? (md5sum remains the same)
Did you try importing into an empty schema so you don't have to set IGNORE=Y? And when you wrote:

The problem persists with rows=N and with only selected tables from this schema.

Did you mean no matter which one or two tables you choose, it still crashes? Try simulating an import with SHOW=Y?

Windows – Import Oracle full dump file to fresh Oracle installation

If you are using the old imp method the users and tablespaces must be created first. This includes grants, database links and any advanced queues you may be using. A sample script could look like this in Windows imp a_DBA_user/apassword LOG =C:\dump\logs\import.log file =user01.dmp fromuser=user_name touser=user_name

The newer datapump method works wonderfully. You don't need to create the user but I would create any custom tablespaces you may have on the original.

A sample data pump call requires you to create a database link to the original database and a directory. This creates a directory

CREATE OR REPLACE DIRECTORY 
DATA_PUMP_DIR AS 
'C:\app\Oracle\product\11.2.0\dbhome_1\rdbms\log\';


GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO EXP_FULL_DATABASE;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO auser;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO IMP_FULL_DATABASE;

In your script to import set these variables NLS_LANG

ORACLE_SID= your database name

impdp a_user_who_exists/your database name directory=DATA_PUMP_DIR network_link=original database name schemas= user1,user2 LOGFILE=DataPump.log TABLE_EXISTS_ACTION=REPLACE

Best Answer

Related Solutions

Oracle imp crashes without error

Windows – Import Oracle full dump file to fresh Oracle installation

Related Question