Shulou(Shulou.com)05/31 Report--

This article is about how oracle 12c imports 11g. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Pre-migration character set view

Sqlplus "/ as sysdba"

Select userenv ('language') from dual

1.

Select tablespace_name from dba_segments where owner=upper ('tnticket2017') group by tablespace_name

The query result is the original tablespace

two。

Query data quantity

Select sum (bytes/1024/1024/1024) "sum (MB)" from dba_segments where owner=upper ('tnticket2017')

3. Create a directory dumpdir (if ignored, the d:\ dumpdir actual file directory must exist)

Create directory dumpdir as'd:\ dumpdir'

# if rac, CLUSTER=N

Expdp directory=dumpdir dumpfile=tnticket20170814.dmp logfile=tnticket20170814.log schemas=tnticket2017 version=11.2.0.1

New database operation

Try to keep the database character set consistent before and after migration, otherwise the data will be processed manually

Create directory dumpdir as'd:\ dumpdir'

According to the results of the above query, create the corresponding tablespace (note that the file path is the same as the existing database file. If you don't know, you can query the following with the following statement)

Select file_name from dba_data_file

Create a tablespace (if the tbs_tnticket is 1, the size of the data file must be queried according to 2)

Create tablespace tbs_tnticket datafile'd:\ app\ oradata\ tbs_tnticket01.dbf' size 8G autoextend off

Impdp directory=dumpdir dumpfile=tnticket20170814.dmp logfile=tnticket20170814.log

Thank you for reading! This is the end of this article on "how to import 11g oracle 12c". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.