Question: I se where I get an
ORA-00959 with impdp because my schema name is specified in
the dump file in lowercase.
I got it to work by creating a new tablespace as my_ts
(in lower case) and then executing the following and the
data were imported.
impdp
VDIADMINT/scott@orcl DIRECTORY=kdump dumpfile=VDIADMIN_DUMP.DMP
remap_schema=myschema:MYSCHEMA
If it's possible to force remap_tablespace to take lower
case tablespace name or if anyone can explain this to me?
Answer: In your original exported
database, the tablespace and schema names where created in
lowercase, by enclosing the names in double-quotes,
not a good idea:
create table "mytab"
. . .
create
tablespace "mt_ts" . . .
create user "my_schema" . . .
These cause the entries to be stored in
the data dictionary as lowercase.
The docs say:
By default, table
names in a database are stored as uppercase.
If you
have a table name in mixed-case or lowercase, and you want
to preserve case-sensitivity for the table name, then you
must enclose the name in quotation marks.
The name
must exactly match the table name stored in the database.
In parameter file mode: TABLES='"Emp"'
