1

Topic: REMAP_SCHEMA It is not correct

Good afternoon! Prompt as correctly  the circuit.
I try to make it such command
impdp '/as sysdba ' directory=export
_test_schema SCHEMAS=cashflow_tfsbuild_cms_build4 remap_schema=cashflow_tfsbuild
_cms_build4:cms_user remap_tablespace=cashflow_tfsbuild_cms_build4:cms_user dum
pfile=qqqq.dmp logfile=sssd.log
At importation attempt tables are rolled, but there is a mass of errors connected with Sequence
It is visible that the full name of the table was replaced, and the object sequence is not present, whether there is a possibility as that it to affect?
ORA-02289: sequence does not exist
Failing sql is:
CREATE TABLE " CMS_USER ". "EXT_SCENARIOS" ("ID" NUMBER (20,0) DEFAULT " CASHFLOW_TFSBUILD_CMS_BUILD4 ". "EXT_SCENARIOS_SEQ". "NEXTVAL" NOT NULL ENABLE, "SRV_REQUEST_ID" NUMBER (20,0), "SRV_REQ_MESSAGE_ID" NUMBER (20,0), "EXT_CALC_REQUEST_ID" NUMBER (20,0) NOT NULL ENABLE, "EXT_CALC_DATE" TIMESTAMP (6) NOT NULL ENABLE, "EXT_SYS_SCENARIO_ID" VARCHAR2 (36 CHAR) NOT NULL ENABLE, "DP_REQUE
ORA-39083: Object type TABLE: "CMS_USER". "EXT_SCENARIO_PARAMS" failed to create with error:
ORA-02289: sequence does not exist

2

Re: REMAP_SCHEMA It is not correct

And ?
The first link in Google produces the answer.
https://asktom.oracle.com/pls/asktom/f? … 0346734356

3

Re: REMAP_SCHEMA It is not correct

Q.Tarantino;
Saw it, but it is a lot of such objects. As that very crookedly looks such decision.
Then still it is necessary manually given to export

4

Re: REMAP_SCHEMA It is not correct

Sm1le2911 wrote:

saw it, but it is a lot of such objects. As that very crookedly looks such decision.
Then still it is necessary manually given to export

Yes it is fine, what difference how many objects?
All can be automated it.
sed and other nobody cancelled and sqlfile to make the necessary.
Beforehand to create objects dataless, then import with table_exist_action = append, for example.

5

Re: REMAP_SCHEMA It is not correct

Q.Tarantino;
It is necessary, it is visible other outputs is not present (
Nightmare that such children's bugs meet in such serious product

6

Re: REMAP_SCHEMA It is not correct

Sm1le2911 wrote:

it is necessary, it is visible other outputs is not present (
Nightmare that such children's bugs meet in such serious product

All where easier than seems...
Separate   it is not necessary.
All on the import side - you prepare sqlfile, sed (well or who that loves) etc.

7

Re: REMAP_SCHEMA It is not correct

p.s. And names of tables on an initial DB with similar fields can be selected beforehand and SQLFILE to create only for them, using include for impdp.