| importing data [message #87840] |
Wed, 16 February 2005 04:58  |
tommy
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
hey guys,
i have exported a database from a pc and trying to import it on my labtop.
i have created a similar database with the same name for that purpose. i used the following
command to export the database: "exp full=y" to get my dump file.
and while trying to import it i used the following command: "imp full=y" and when i was
asked for the username and password i wrote the following: "user@databaseName" and "password"
i got the following error:
/****
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified
IMP-00000: Import terminated unsuccessfully
***/
can anyone tell me how to fix that??
thanx,
Tommy
|
|
|
|
| Re: importing data [message #87841 is a reply to message #87840] |
Wed, 16 February 2005 05:20  |
tommy
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
i'm using the following now:
/****
C:>imp system@oraclev1/ojaus file=c:EXPDAT>DMP full=yes
Import: Release 9.2.0.1.0 - Production on Wed Feb 16 16:04:05 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
****/
and it is stopping and not doing anything.
thanx,
Tommy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
