export/import (user mode)
can you help me please,
1- I exported the SCOTT schema (user mode):
exp scott/tiger FILE=D:\scott.dat LOG=D:\scott_exp.log OWNER=SCOTT
then I imported to new created before schema SCOTT_COPY:
imp scott_copy/tiger FILE=D:\scott.dat LOG=D:\scott_imp.log
fromuser=scott
touser=scott_copy
I got in scott_copy only tables from scott (all existed types were not successful imported) WHY only tables (see log)!!.
2- What is the best way to export user and import it with all (objects and privilegs granted to origin user).
thanks
jamil
see scott_imp.log
=================
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ADDRESS_OBJ" TIMESTAMP '2002-02-08:10:15:23' OID '8AB6D00504B0"
"47A9BDAC02E58E4298A0' as object("
"pobox varchar2(20),"
"street varchar2(20),"
"city varchar2(20),"
"state varchar2(20),"
"country varchar2(20))"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "BREAD_LIST" TIMESTAMP '2002-02-08:10:13:03' OID 'D9896A6992394"
"4F58D608A3ED01791D6' as array(10) of bread_obj;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "BREAD_OBJ" TIMESTAMP '2002-02-08:10:10:55' OID '24F457B9807C47"
"B9B753CEC5E88D584A' as object("
"bread_id number(2),"
"bread_name varchar2(20),"
"sale_price number(5,2),"
"in_stock number(4));"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "INGREDIENT_OBJ" TIMESTAMP '2002-02-08:10:11:39' OID '8A39AD416"
"8DF411995F0B2B2020BF731' as object("
"ing_id number(2),"
"name varchar(20),"
"price number(5,2),"
"in_store number (8,3))"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
. . importing table "A" 13 rows imported
. . importing table "ACCOUNT" 5 rows imported
. . importing table "B" 5 rows imported
. . importing table "BONUS" 0 rows imported
. . importing table "DEPT" 5 rows imported
. . importing table "EMP" 13 rows imported
. . importing table "EMP1" 14 rows imported
. . importing table "EMP_SNAPSHOT" 14 rows imported
. . importing table "RECEIPT" 1 rows imported
. . importing table "SALGRADE" 5 rows imported
. . importing table "T" 12 rows imported
. . importing table "TABLE_RESULT" 5 rows imported
. . importing table "TEMP" 3 rows imported
. . importing table "XXX" 0 rows imported
About to enable constraints...
Import terminated successfully with warnings.