Can you please tell me how to import the tables I need from the backup? Do the next way

#imp MILLER/KOLOBOK FILE=file.DAT LOG=logf.log feedback=1000 tables=(t1,t2,t3,t4) FULL = Y;

I get a syntax error '(' if you remove the parentheses, import does not start, if you remove full, nothing happens either. Tell me what am I doing wrong?

  • @lDrakonl already worn out, I apologize, corrected - Ethernets
  • when you specify the FULL=Y parameter, it imports the entire database. Most likely it is not possible to specify a list of tables and write FULL=Y Still try to remove the spaces inside FULL = Y - Viktorov
  • And still the grid does not mean, at first, commenting out the entire line? - Viktorov

1 answer 1

You have a list of tables and the FULL = Y parameter is specified. You can not do it this way. Either the entire database, or separate tables. At the same time, the list of tables is not tied to schemas. The table name can be repeated within the schema.

Depending on the task required:

1) Import the entire database. Remove the table listing. FULL=Y means the import of the entire database.

2) Import the necessary tables. Use the parameters FROMUSER , TOUSER , TABLES and FULL=N FROMUSER and TOUSER do not have to be the same.

I recommend avoiding unnecessary spaces inside the parameters. Under Windows, this led to weird reading of parameters.

  • Let's take it in order: - there are no spaces, made here for better readability. I already understood that Full = y is the import of the entire database, but in another topic I ran into a problem that I don’t know how to get around because of this problem, sys and system have flown. If I remove FULL, then the encoding of 2 pieces is imported. and the process ends. During the day I tried all the options except for the choice of users. And I have a CentOS7 OS. And still there can be no problems with the fact that exp was shot from 10g Win serv 2003 and imp to 11g2 CentOS7 ?? - Ethernets
  • # means the start of the command line - Ethernets
  • Versions do not matter. This is the essence. Export was shot using exp or expdp ? - Viktorov
  • exp I already encountered this, one is not friendly with the other)) - Ethernets
  • one
    Scheme in terms of oracle is a user. When accessing tables, tables get the address <имя пользователя(схема)>.<имя таблицы> . If only the 1st user tables are needed, use the fromuser and touser and list the required tables. In general, if you gave your example with the names of your tables, and not from the textbook, it would be easier - Viktorov