Oracle creates databases and imports data

A new database

1 Sql>conn/as sysdba//Use SYS login

2 sql>create tablespace space1 datafile ' D:\oracle\JG.dbf ' size 1000M autoextend on; Space1 table space name, creating tablespace

3 Create user User1 identified by 123 default Tablespace Space1; Create User and password

4 Grant CONNECT,RESOURCE,DBA to Username; User permissions

5 commit; Submit

Two, import: oracle.dmp//oracle database file

1 Running > cmd

2 c:\users\administrator> Imp//carriage

31 Step by step, note the options, ignore the existing table selection Yes,

Third, Oracle occupies 8080 port problem resolution

1 run >cmd >netstat-ano |findstr "8080" to see if Oracle is occupied

2 Entering Oracle,sql>

3 Sys Landing,

Sql>conn/as SYSDBA//Use SYS login

4 Modify Port

Sql>call dbms_xdb.cfg_update (Updatexml (dbms_xdb.cfg_get), '/xdbconfig/sysconfig/protocolconfig/httpconfig/ Http-port/text () ', 9081));

5 Submit sql>commit;

6 Refresh Sql>exec Dbms_xdb.cfg_refresh;