Oracle create user data import

Create JXDW2014 User Password JXDW and grant DBA permission

Enter the sqlplus password in the Start Menu, as shown in the following code:

Other permissions include:

Grant unlimited tablespace to JXDW2014; -- grant unlimited tablespace

Grant select any table to JXDW2014; -- grant query to any table

Grant select any dictionary to JXDW2014; -- grant query to any dictionary

Data Import

Enter CMD

Password: imp account/password @ database instance file = d: \ data file to be imported full = y ignore = y