Turn to the great god, the couple beginners Oracle problems encountered in the process of data impor-CodePudding

New beginner Oracle, when importing a DMP data has been an error in the process of

,
Online access methods can not solve, and then I tried a new a VEHICLE_POSITION table, and then to import, or complains, but prompt table does not exist error, an error is

,
The problem of insufficient permissions, according to the online access scheme is also not solve, the award for a new user permissions were given, and then I tried in Oracle default user VEHICLE_POSITION new form, then import the default user, or you don't succeed, but any mistakes are not prompted

Help you a great god, and guide,

CodePudding user response:

What is the export and import statements?

CodePudding user response:

reference 1st floor minsic78 response:

export and import statements?

Imp imp # GF/123456 c # file=D: \ app \ GF \ oradata \ VEHICLE_POSITION_20150612 DMP full=ignore y=y

CodePudding user response:

refer to the second floor fenghuanggf23 response:

Quote: refer to 1st floor minsic78 response:

What is the export and import statements?

Imp imp # GF/123456 c # file=D: \ app \ GF \ oradata \ VEHICLE_POSITION_20150612 DMP full=y ignore=y

You this is just between two users object of export and import, don't use the full, with fromuser=taxicd touser=c # # GF is enough

CodePudding user response:

refer to the second floor fenghuanggf23 response:

Quote: refer to 1st floor minsic78 response:

What is the export and import statements?

Imp imp # GF/123456 c # file=D: \ app \ GF \ oradata \ VEHICLE_POSITION_20150612 DMP full=y ignore=y

To get the data from other sources, I do not know export statements, import statements is above this, well write an imp

CodePudding user response:

reference minsic78 reply: 3/f

Quote: refer to the second floor fenghuanggf23 response:

Quote: refer to 1st floor minsic78 response:

What is the export and import statements?

Imp imp # GF/123456 c # file=D: \ app \ GF \ oradata \ VEHICLE_POSITION_20150612 DMP full=y ignore=y

You this is just between two users object of export and import, don't use the full, with fromuser=taxicd touser=c # # GF is enough

You said this is tried, like in full

CodePudding user response:

Under studying the topic, because if it's not a BUG, is there such a possibility?

This import table constraints or primary key contains the only index is belong to other users, rather than TAXICD users? The original poster can be generated by imp INDEXFILE options under the table DDL statements to see, is probably the tables and indexes belonging to different users, if so are better handled:

The DDL statement to create table is obtained by INDEXFILE options first, if the table data volume is small, can take on the primary key is built first, and then through the ignore=y or data_only=y parameter to complete data import, if the table data quantity is large, then you can lead into data, add a primary key after the import is complete,

CodePudding user response:

refer to 6th floor minsic78 response:

under studying the topic, because if it's not a BUG, is there such a possibility?

This import table constraints or primary key contains the only index is belong to other users, rather than TAXICD users? The original poster can be generated by imp INDEXFILE options under the table DDL statements to see, is probably the tables and indexes belonging to different users, if so are better handled:

The DDL statement to create table is obtained by INDEXFILE options first, if the table data volume is small, can take on the primary key is built first, and then through the ignore=y or data_only=y parameter to complete data import, if the table data volume is larger, can be the guide into data, add a primary key after the import is complete,

Is to use imp # # GF/123456 file=D: \ app \ GF \ oradata \ VEHICLE_POSITION DMP indexfile=D: \ app \ GF \ oradata \ VEHICLE_POSITION independence idx full=y this statement, I use this error

CodePudding user response:

refer to 7th floor fenghuanggf23 response:

Quote: refer to the sixth floor minsic78 response:

Under studying the topic, because if it's not a BUG, is there such a possibility?

This import table constraints or primary key contains the only index is belong to other users, rather than TAXICD users? The original poster can be generated by imp INDEXFILE options under the table DDL statements to see, is probably the tables and indexes belonging to different users, if so are better handled:

The DDL statement to create table is obtained by INDEXFILE options first, if the table data volume is small, can take on the primary key is built first, and then through the ignore=y or data_only=y parameter to complete data import, if the table data volume is larger, can be the guide into data, add a primary key after the import is complete,

Is to use imp # # GF/123456 file=D: \ app \ GF \ oradata \ VEHICLE_POSITION DMP indexfile=D: \ app \ GF \ oradata \ VEHICLE_POSITION independence idx full=y this statement, I have an error with this

If so, if you want to determine clear problem is more troublesome, if production database is the following carefully:

1, open the whole library level 1031 error tracking:
The alter system set events: '1031 trace name errorstack forever, level 3';
2, imp import, error, find the corresponding TRC imp session file, usually is the latest tracking file, if it's 11 g, a trace file directory under the user_dump_dest instance parameter specifies the directory, according to the file timestamp order find it
After 3, find the trace files, you can see more information about ORA - 1031 error, can do further diagnosis,

If it is a production base, feel do have concerns, or feel that the above process is too much trouble, it is recommended that the contact data source database administrator, go and see this list if you have any special constraints in addition to belong to other users, you should also consider whether there will be a foreign key references to other user object, and the user does not exist in the target library,

Additionally, actually imp has to enable the constraint in this step, table data should be imported, if as long as the data, to this point have to OK, if you ignore each use=y to import data, this list of data may already have repeated,

CodePudding user response:

Supplement, forgot to remind, if opened 1031 errorstack, so after the tracking remember to shut it down:
The alter system set events' 1031 trace name errorstack off '.

CodePudding user response:

references 9 f minsic78 response:

added, forgot to remind, if opened 1031 errorstack, then tracking finished remember to shut it down:
The alter system set events' 1031 trace name errorstack off '.

Thank you for your advice, 1031 of the problem has been solved, the problem of the 942 hasn't been solved,

CodePudding user response:

references 9 f minsic78 response:

added, forgot to remind, if opened 1031 errorstack, then tracking finished remember to shut it down:
The alter system set events' 1031 trace name errorstack off '.

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull