Shulou(Shulou.com)06/01 Report--

Query database language and character set

Select userenv ('language') from dual

Select * from nls_database_parameters # server

Select * from nls_instance_parameters # client

Select * from nls_session_parameters # session

View dump file export information

Strings bak20190315.dmp | head-10

Strings bak20190315.dmp | grep "CREATE TABLE" | awk'{print $3}'| sed's / "/ / g'# table

Cat exp.dmp | od-x | head-1 | awk'{print $2 $3}'| cut-c 3-6 # View character set codes

Select nls_charset_name (to_number ('0354)) from dual; # code conversion to name

Create user note identified by luoluo; # user Authorization

Grant connect,resource to note

Select name from vault datafile; # query the data file path

Create tablespace note datafile='/u01/app/oracle/oradata/orcl/note01.dbf' size 31G; # create a new tablespace

Alter tablespace note add datafile='/u01/app/oracle/oradata/orcl/note02.dbf' size 31G

Alter tablespace note add datafile='/u01/app/oracle/oradata/orcl/note03.dbf' size 31G

Alter tablespace note add datafile='/u01/app/oracle/oradata/orcl/note04.dbf' size 31G

Alter user note default tabspace note; # modify user default tablespace

Imp system/ORACLE12C file=/mnt/data/bak20190315.dmp FROMUSER=NOTE

Reference link

Https://www.cnblogs.com/lipera/p/6201434.html

Https://www.cnblogs.com/lhrbest/p/6832707.html

Https://www.cnblogs.com/rootq/articles/2049324.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.