asked on

import DB to oracle 10 failed

Hi

i am trying to import db to 10g and the command is running on dos command window without do anything
and without any errors.

1. i installed the oracle 10g on a cleen computer.
2. create new database.
3. connect the net manager after create listener.
4. connect the SQL+.
5. test tnsping wyne - OK
6. add path to the folder of dmp file and import batch.

and run the command from dos or batch and it is just running the command again and again
please see the screen shot.

any idea?

the command is: imp system/oracle@wyne file=file.dmp full=y buffer=5000000 log=imp.log

10x

screen.jpg

Ravindran Gopinathan

What happens when you just type imp at command prompt? You can the interactive mode, wherein you would be entering the parameters whenever asked. Probably you might have to set ORACLE_SID to your instance before starting (just in case there are more than one instances on the machine)

This is the first time am seeing something like this happening!

gudidi

ASKER

hi

the same haapends from any where.
the oracle sid is OK.

any idea? i am despert :-)

gudidi

ASKER

can it be because the file name is file.dmp?

Ravindran Gopinathan

There is nothing wrong with the file name.

What happens when you just type "imp"? Does it work?

gudidi

ASKER

the same happens when i type imp from every where in dos command.
like this batch file burn on the disk.

gudidi

ASKER

hi ravin...

you won't believe it.
i changed the name of the batch to import.bat and it started to work.
magic.

anyway thanks and take the points.

10x

ASKER CERTIFIED SOLUTION

Ravindran Gopinathan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ravindran Gopinathan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gudidi

ASKER

now i understood it

thanks a lot.