IMP FROM TO

Hi,

Try like this.....

imp system/<password> file=scott.dmp log=stest.log show=Y fromuser=scott touser=stest statistics=safe ignore=y

Here... you are using both the ways i.e. FULL=y and FROMUSER.

As the dump is scott.dmp so just remove FULL=Y ...it works.

Happy dumping.... :-)

1. You should use either full=Y or fromuser=xxx option.. so just remove full=y, then it should be ok
2. There is another warning on the character set conversion; you should set your NLS_LANG to US7ASCII, to let the import do the automatic charset conversion for you. The way to do this is to
a. set the system environment variable through control panel > system
b. in unix ksh, do export NLS_LANG=american_america.US7ASCII


Export file created by EXPORT:V10.02.01 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified
IMP-00000: Import terminated unsuccessfully

when I tried to import to STEST user. Only Global temporary tables go creates I donot use any other objects inside the schema.

below is the import command I am using

imp userid=scott file=sadmin.dmp show=Y fromuser=SADMIN touser=STEST ignore=y log=imp_STEST.log

Thanks

can you paste your log file imp_STEST.log to see what it has written there...

full=Y show=Y fromuser=scott touser=stest
is wrong

drop

full=Y show=Y

show=y causes NO IMPORT, only the SQL statements will be shown in the log file

Use this:

SHOW=n
IGNORE=y
GRANTS=y
ROWS=y

I see message. And it is for all tables.

 "TABLESPACE "STEST_DATA" LOGGING NOCOMPRESS"
. . skipping table "EMPLOYEES"

But I dont understand why it is skipping tables.

Thanks

i think you did not see the update of "schwertner". Can you check that update.

Now I am getting new error

Below is the message from imp log

IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
 "CREATE TYPE "SYS_PLSQL_12283_175_2" TIMESTAMP '2008-08-07:13:38:37' OID '53"
 "E228AD415B0C0DE0440017A4AB7097'             as table of SCOTT."EMPLOYEES"
 "12283_30_2";"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal

Select allOpen in new window

Yoi should import with equal or higher version of Import utility.
Use "SYS as sysdba" account.

btw, could you check what's SYS_PLSQL_12283_174_2? could you describe SCOTT.EMPLOYEES table, and use a type created by SCOTT instead of SYS?

I think problem is bcoz I am trying to export and import from one user to another user in same database. And that is giving error. But I am not sure how to resolve this issue.

Thanks

It is possible.
But if you use old Export/Import the tablespace and the new user must exist.

The new user is exisit and he is assign to different tablespace...

Thanks

Thank you