Oracle Data Import Summary

Welcome to the Oracle Community Forum, interact with 2 million technical staff and enter oracle export data summary make a summary about Database Export so that you can find and export your own table expuserid username and password @ database instance name tables (table 1, Table 2 ...) File backup path, for example, export the scott. emp table expuseridscottm123 @ o

Welcome to the Oracle Community Forum, interaction with 2 million technical personnel> enter oracle Data Import summary about Database Export to facilitate searching and exporting your own table exp userid = username/password @ database instance name tables = (Table 1, table 2 ...) File = backup path, for example, export scott. emp table exp userid = scott/m123 @ o

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Oracle Data Import Summary

Make a summary about Database Export to facilitate future search

Export your own table

Exp userid = username/password @ database instance name tables = (table 1, Table 2 ...) File = backup path

For example, export the scott. emp table.

Exp userid = scott/m123 @ CMDL tables = (emp. dept) file = d:/emp. dmp

Must be executed in dos

Tables under others' solutions

Exp userid = username/password @ database instance name tables = (solution name. Table 1, solution name. Table 2 ...) File = backup path

Structure of the exported table

Exp userid = username/password @ database instance name tables = (table 1, Table 2 ...) File = backup path rows = n

Export tables directly (mainly to speed up)

Exp userid = username/password @ database instance name tables = (table 1, Table 2 ...) File = backup path direct = y

Export Scheme

Exp userid = username/password @ database instance name owner = username file = backup path