• Oracle 逻辑备份（数据迁移）

    以逻辑结构为单位进行的备份

    • 跨用户移动数据
    • 跨数据库移动数据库
    • 为测试保存原始的数据状态
    • 对数据库进行版本升级

    逻辑导出的注意事项：

    • exp程序在目录中发现同名文件时会直接覆盖，不提示！！
    • exp无法备份无段的空表
    • 执行逻辑导出时一定要注意字符集！最好使用包含中文的小表做测试！！
    • 执行逻辑导出时一定要注意字符集！最好使用包含中文的小表做测试！！
    • 导入时的数据和导出时的数据一模一样，导出之后数据库中表的数据变化全都丢失！！

    逻辑导出：所有版本都可用，服务器端和客户端都可用。

    mkdir -p /home/oracle/expbk

    exp userid=scott/tiger@pdb1 table=t01 file=/home/oralce/expbk/t01.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/t01.log

    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ exp userid=scott/tiger@PDB1 tables=emp file=/home/oracle/expbk/emp.dmp buffer=1048576 log=/home/oracle/expbk/emp.log
    3.  
    4. Export: Release 19.0.0.0.0 - Production on Mon Dec 5 23:34:37 2022
    5. Version 19.3.0.0.0
    6.  
    7. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    8.  
    9.  
    10. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12. Export done in US7ASCII character set and AL16UTF16 NCHAR character set
    13. server uses AL32UTF8 character set (possible charset conversion)
    14.  
    15. About to export specified tables via Conventional Path ...
    16. . . exporting table                            EMP         14 rows exported
    17. EXP-00091: Exporting questionable statistics.
    18. EXP-00091: Exporting questionable statistics.
    19. Export terminated successfully with warnings.
    20. [oracle@oracle-db-19c expbk]$

    逻辑导入：

    drop table t01 purge;

    imp userid=scott/tiger tables=t01 file=/home/oracle/expbk/t01.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/t01.log

    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ imp userid=scott/tiger@PDB1 tables=emp file=/home/oracle/expbk/emp.dmp buffer=1048576 log=/home/oracle/expbk/imp_emp.log
    3.  
    4. Import: Release 19.0.0.0.0 - Production on Tue Dec 6 18:13:14 2022
    5. Version 19.3.0.0.0
    6.  
    7. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    8.  
    9.  
    10. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12.  
    13. Export file created by EXPORT:V19.00.00 via conventional path
    14. import done in UTF8 character set and AL16UTF16 NCHAR character set
    15. import server uses AL32UTF8 character set (possible charset conversion)
    16. export client uses US7ASCII character set (possible charset conversion)
    17. . importing SCOTT's objects into SCOTT
    18. . importing SCOTT's objects into SCOTT
    19. . . importing table                          "EMP"         14 rows imported
    20. About to enable constraints...
    21. Import terminated successfully without warnings.
    22. [oracle@oracle-db-19c expbk]$

    导出数据时带有查询条件：

    exp scott/tiger tables=emp file=/home/oracle/expbk/emp_30.dmp query=\'where deptno=30\' buffer=1000000 log=/home/oracle/expbk/emp_30.log
    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ exp scott/tiger@PDB1 tables=emp file=/home/oracle/expbk/emp_30.dmp query=\'where deptno=30\' buffer=1000000 log=/home/oracle/expbk/emp_30.log
    3.  
    4. Export: Release 19.0.0.0.0 - Production on Tue Dec 6 18:30:18 2022
    5. Version 19.3.0.0.0
    6.  
    7. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    8.  
    9.  
    10. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12. Export done in UTF8 character set and AL16UTF16 NCHAR character set
    13. server uses AL32UTF8 character set (possible charset conversion)
    14.  
    15. About to export specified tables via Conventional Path ...
    16. . . exporting table                            EMP          6 rows exported
    17. EXP-00091: Exporting questionable statistics.
    18. EXP-00091: Exporting questionable statistics.
    19. Export terminated successfully with warnings.
    20. [oracle@oracle-db-19c expbk]$ ls -ltr
    21. total 48
    22. -rw-r--r--. 1 oracle oinstall   516 Dec  5 23:34 emp.log
    23. -rw-r--r--. 1 oracle oinstall 16384 Dec  5 23:34 emp.dmp
    24. -rw-r--r--. 1 oracle oinstall   614 Dec  6 18:13 imp_emp.log
    25. -rw-r--r--. 1 oracle oinstall   153 Dec  6 18:21 employees.log
    26. -rw-r--r--. 1 oracle oinstall   512 Dec  6 18:30 emp_30.log
    27. -rw-r--r--. 1 oracle oinstall 16384 Dec  6 18:30 emp_30.dmp
    28. [oracle@oracle-db-19c expbk]$

     

    导入时追加数据：ignore=y

    （1）删除30部门的数据。

    1. SQL> 
    2. SQL> delete emp where deptno=30;
    3.  
    4. 6 rows deleted.
    5.  
    6. SQL> commit;
    7.  
    8. Commit complete.
    9.  
    10. SQL> select * from emp;
    11.  
    12.      EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
    13. ---------- ---------- --------- ---------- --------- ---------- ---------- ----------
    14.       7369 SMITH      CLERK           7902 17-DEC-80        800                    20
    15.       7566 JONES      MANAGER         7839 02-APR-81       2975                    20
    16.       7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
    17.       7788 SCOTT      ANALYST         7566 24-JAN-87       3000                    20
    18.       7839 KING       PRESIDENT            17-NOV-81       5000                    10
    19.       7876 ADAMS      CLERK           7788 02-APR-87       1100                    20
    20.       7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
    21.       7934 MILLER     CLERK           7782 23-JAN-82       1300                    10
    22.  
    23. 8 rows selected.
    24.

     （2）导入备份数据到表中

    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ imp scott/tiger@PDB1 tables=emp file=/home/oracle/expbk/emp_30.dmp ignore=y buffer=100000 log=/home/oracle/expbk/imp_emp_30.log
    3.  
    4. Import: Release 19.0.0.0.0 - Production on Tue Dec 6 18:33:35 2022
    5. Version 19.3.0.0.0
    6.  
    7. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    8.  
    9.  
    10. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12.  
    13. Export file created by EXPORT:V19.00.00 via conventional path
    14. import done in UTF8 character set and AL16UTF16 NCHAR character set
    15. import server uses AL32UTF8 character set (possible charset conversion)
    16. . importing SCOTT's objects into SCOTT
    17. . importing SCOTT's objects into SCOTT
    18. . . importing table                          "EMP"          6 rows imported
    19. About to enable constraints...
    20. Import terminated successfully without warnings.
    21. [oracle@oracle-db-19c expbk]$

     （3）查询数据

    1. SQL> select * from emp;
    2.  
    3.      EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
    4. ---------- ---------- --------- ---------- --------- ---------- ---------- ----------
    5.       7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
    6.       7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
    7.       7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
    8.       7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
    9.       7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
    10.       7900 JAMES      CLERK           7698 03-DEC-81        950                    30
    11.       7369 SMITH      CLERK           7902 17-DEC-80        800                    20
    12.       7566 JONES      MANAGER         7839 02-APR-81       2975                    20
    13.       7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
    14.       7788 SCOTT      ANALYST         7566 24-JAN-87       3000                    20
    15.       7839 KING       PRESIDENT            17-NOV-81       5000                    10
    16.       7876 ADAMS      CLERK           7788 02-APR-87       1100                    20
    17.       7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
    18.       7934 MILLER     CLERK           7782 23-JAN-82       1300                    10
    19.  
    20. 14 rows selected.
    21.  
    22. SQL>

     闪回导出： 只有system可以调用

    exp system/system@PDB1 tables=scott.emp file=/home/oracle/expbk/emp_1010.dmp buffer=1000000 flashback_time=\"to_timestamp\(\'2022-12-06 19:00:00\',\'yyyy-mm-dd hh24:mi:ss'\)\" log=/home/oracle/expbk/emp_1010.log
    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ exp system/system@PDB1 tables=scott.e03 file=/home/oracle/expbk/e03_1930.dmp buffer=1000000 flashback_time=\"to_timestamp\(\'2022-12-06 19:30:00\',\'yyyy-mm-dd hh24:mi:ss\'\)\" log=/home/oracle/expbk/e03_1930.log
    3.  
    4. Export: Release 19.0.0.0.0 - Production on Tue Dec 6 19:47:12 2022
    5. Version 19.3.0.0.0
    6.  
    7. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    8.  
    9.  
    10. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    11. Version 19.3.0.0.0
    12. Export done in UTF8 character set and AL16UTF16 NCHAR character set
    13. server uses AL32UTF8 character set (possible charset conversion)
    14.  
    15. About to export specified tables via Conventional Path ...
    16. Current user changed to SCOTT
    17. . . exporting table                            E03         14 rows exported
    18. EXP-00091: Exporting questionable statistics.
    19. Export terminated successfully with warnings.
    20. [oracle@oracle-db-19c expbk]$

    导入数据：

    1. [oracle@oracle-db-19c expbk]$ imp system/system@PDB1 file=/home/oracle/expbk/e03_1930.dmp full=y ignore=y
    2.  
    3. Import: Release 19.0.0.0.0 - Production on Tue Dec 6 19:49:06 2022
    4. Version 19.3.0.0.0
    5.  
    6. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    7.  
    8.  
    9. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    10. Version 19.3.0.0.0
    11.  
    12. Export file created by EXPORT:V19.00.00 via conventional path
    13. import done in UTF8 character set and AL16UTF16 NCHAR character set
    14. import server uses AL32UTF8 character set (possible charset conversion)
    15. IMP-00403: 
    16.  
    17. Warning: This import generated a separate SQL file "import_sys" which contains DDL that failed due to a privilege issue.
    18.  
    19. . importing SYSTEM's objects into SYSTEM
    20. . importing SCOTT's objects into SCOTT
    21. . . importing table                          "E03"         14 rows imported
    22. Import terminated successfully with warnings.
    23. [oracle@oracle-db-19c expbk]$

    只导出表结构（元数据）不导出数据：备份模型，不备份数据

    1. exp scott/tiger@PDB1 tables=ob1 rows=n file=/home/oracle/expbk/ob1_metadata.dmp log=/home/oracle/expbk/ob1_metadata.log
    2.

     

    select object_name,created from user_objects;

    vi /home/oracle/expbk/exp.sh

    1. export ORACLE_HOME = $ORACLE_BASE/product/19.3.0/dbhome_1
    2. export ORACLE_SID = PDB1
    3. export LANG=en_US.UTF-8
    4. export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    5. name=`date '+%Y%m%d_%H%M%s'`
    6. `$ORACLE_HOME/bin/exp userid=scott/tiger@PDB1 tables=t01 file=/home/oracle/expbk/t01\_$name.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/t01\_$name.log`
    7.  
    chmod +x /home/oracle/expbk/exp.sh

     

    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ sh -x exp.sh   
    3. + export ORACLE_HOME = /u01/app/oracle/product/19.3.0/dbhome_1
    4. exp.sh: line 2: export: `=': not a valid identifier
    5. exp.sh: line 2: export: `/u01/app/oracle/product/19.3.0/dbhome_1': not a valid identifier
    6. + export ORACLE_SID = PDB1
    7. exp.sh: line 3: export: `=': not a valid identifier
    8. + export LANG=en_US.UTF-8
    9. + LANG=en_US.UTF-8
    10. + export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    11. + NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    12. ++ date +%Y%m%d_%H%M%S
    13. + name=20221206_20191670329163
    14. ++ /u01/app/oracle/product/19.3.0/dbhome_1/bin/exp userid=scott/tiger@PDB1 tables=t01 file=/home/oracle/expbk/t01_20221206_20191670329163.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/t01_20221206_20191670329163.log
    16. Export: Release 19.0.0.0.0 - Production on Tue Dec 6 20:19:23 2022
    17. Version 19.3.0.0.0
    19. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    22. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    23. Version 19.3.0.0.0
    24. Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
    26. About to export specified tables via Conventional Path ...
    27. . . exporting table                            T01
    28.                                                            14 rows exported
    29. Export terminated successfully without warnings.
    30. [oracle@oracle-db-19c expbk]$ cat exp.sh
    32. export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
    33. export ORACLE_SID=PDB1
    34. export LANG=en_US.UTF-8
    35. export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    36. name=`date '+%Y%m%d_%H%M%s'`
    37. `$ORACLE_HOME/bin/exp userid=scott/tiger@PDB1 tables=t01 file=/home/oracle/expbk/t01\_$name.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/t01\_$name.log`
    38. [oracle@oracle-db-19c expbk]$ 
    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ echo $ORACLE_HOME
    3. /u01/app/oracle/product/19.3.0/dbhome_1
    4. [oracle@oracle-db-19c expbk]$ echo $ORACLE_BASE
    5. /u01/app/oracle
    6. [oracle@oracle-db-19c expbk]$

    导出用户：

    1. exp userid=scott/tiger@PDB1 owner=scott file=/home/oracle/expbk/scott.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/scott.log
    2.  
    1. [oracle@oracle-db-19c expbk]$ 
    2. [oracle@oracle-db-19c expbk]$ 
    3. [oracle@oracle-db-19c expbk]$ exp userid=scott/tiger@PDB1 owner=scott file=/home/oracle/expbk/scott.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/scott.log
    4.  
    5. Export: Release 19.0.0.0.0 - Production on Tue Dec 6 20:29:06 2022
    6. Version 19.3.0.0.0
    7.  
    8. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    9.  
    10.  
    11. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    12. Version 19.3.0.0.0
    13. Export done in UTF8 character set and AL16UTF16 NCHAR character set
    14. server uses AL32UTF8 character set (possible charset conversion)
    15. . exporting pre-schema procedural objects and actions
    16. . exporting foreign function library names for user SCOTT 
    17. . exporting PUBLIC type synonyms
    18. . exporting private type synonyms
    19. . exporting object type definitions for user SCOTT 
    20. About to export SCOTT's objects ...
    21. . exporting database links
    22. . exporting sequence numbers
    23. . exporting cluster definitions
    24. . about to export SCOTT's tables via Conventional Path ...
    25. . . exporting table                          BONUS
    26.                                                             0 rows exported
    27. EXP-00091: Exporting questionable statistics.
    28. . . exporting table                           DEPT
    29.                                                             4 rows exported
    30. EXP-00091: Exporting questionable statistics.
    31. EXP-00091: Exporting questionable statistics.
    32. . . exporting table                            E01
    33.                                                            13 rows exported
    34. EXP-00091: Exporting questionable statistics.
    35. . . exporting table                            E03
    36.                                                            14 rows exported
    37. EXP-00091: Exporting questionable statistics.
    38. . . exporting table                            EMP
    39.                                                            14 rows exported
    40. EXP-00091: Exporting questionable statistics.
    41. EXP-00091: Exporting questionable statistics.
    42. . . exporting table                    EMP_AGGR_MV
    43.                                                             3 rows exported
    44. . . exporting table                       SALGRADE
    45.                                                             5 rows exported
    46. EXP-00091: Exporting questionable statistics.
    47. . . exporting table                            T01
    48.                                                            14 rows exported
    49. EXP-00091: Exporting questionable statistics.
    50. . . exporting table                           TAB1
    51.                                                             0 rows exported
    52. EXP-00091: Exporting questionable statistics.
    53. . . exporting table                           TAB2
    54.                                                             0 rows exported
    55. EXP-00091: Exporting questionable statistics.
    56. . exporting synonyms
    57. . exporting views
    58. . exporting stored procedures
    59. . exporting operators
    60. . exporting referential integrity constraints
    61. . exporting triggers
    62. . exporting indextypes
    63. . exporting bitmap, functional and extensible indexes
    64. . exporting posttables actions
    65. . exporting materialized views
    66. . exporting snapshot logs
    67. . exporting job queues
    68. . exporting refresh groups and children
    69. . exporting dimensions
    70. . exporting post-schema procedural objects and actions
    71. . exporting statistics
    72. Export terminated successfully with warnings.
    73. [oracle@oracle-db-19c expbk]$

    先删除SCOTT用户：

    1. SQL> 
    2. SQL> show user
    3. USER is "SYS"
    4. SQL> show con_name
    5.  
    6. CON_NAME
    7. ------------------------------
    8. CDB$ROOT
    9. SQL> 
    10. SQL> drop user scott cascade;
    11. drop user scott cascade
    12.           *
    13. ERROR at line 1:
    14. ORA-01918: user 'SCOTT' does not exist
    15.  
    16.  
    17. SQL> 
    18. SQL> alter session set container=PDB1;
    19.  
    20. Session altered.
    21.  
    22. SQL> drop user scott cascade;
    23.  
    24. User dropped.
    25.  
    26. SQL> 
    27. SQL> 
    28. SQL> 
    29. SQL> grant connect,resource to scott identified by tiger;
    30.  
    31. Grant succeeded.
    32.  
    33. SQL> conn scott/tiger@PDB1;
    34. Connected.
    35. SQL> select * from emp;
    36. select * from emp
    37.               *
    38. ERROR at line 1:
    39. ORA-00942: table or view does not exist
    40.  
    41.  
    42. SQL>

    导入用户：

    1. imp userid=scott/tiger full=y file=/home/oracle/expbk/scott.dmp buffer=1048576 feedback=10000 log=/home/oracle/expbk/impscott.log
    2.

    跨用户导入数据 ： scott ---> tom

    imp userid=system/system@PDB1 file=scott.dmp fromuser=scott touser=tom tables=dept,emp,salgrade buffer=1000000 log=imptom.log

    使用主机管道压缩备份文件：

    mknod /home/oracle/expbk/exp_pipe p

    1. exp userid=scott/tiger@PDB1 owner=scott log=/home/oracle/expk/scott.log file=/home/oracle/expbk/exp_pipe & gzip </home/oracle/expbk/exp_pipe> scott.dmp.gz
    2.  
    1. [oracle@oracle-db-19c expbk]$ exp userid=scott/tiger@PDB1 owner=scott log=/home/oracle/expbk/scott.log file=/home/oracle/expbk/exp_pipe & gzip </home/oracle/expbk/exp_pipe> scott.dmp.gz
    2. [1] 87055
    3. -bash: /home/oracle/expbk/exp_pipe: No such file or directory
    4. [oracle@oracle-db-19c expbk]$ 
    5. Export: Release 19.0.0.0.0 - Production on Tue Dec 6 21:13:04 2022
    6. Version 19.3.0.0.0
    7.  
    8. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    9.  
    10.  
    11. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    12. Version 19.3.0.0.0
    13. Export done in US7ASCII character set and AL16UTF16 NCHAR character set
    14. server uses AL32UTF8 character set (possible charset conversion)
    15. . exporting pre-schema procedural objects and actions
    16. . exporting foreign function library names for user SCOTT 
    17. . exporting PUBLIC type synonyms
    18. . exporting private type synonyms
    19. . exporting object type definitions for user SCOTT 
    20. About to export SCOTT's objects ...
    21. . exporting database links
    22. . exporting sequence numbers
    23. . exporting cluster definitions
    24. . about to export SCOTT's tables via Conventional Path ...
    25. . . exporting table                          BONUS          0 rows exported
    26. EXP-00091: Exporting questionable statistics.
    27. . . exporting table                           DEPT          4 rows exported
    28. EXP-00091: Exporting questionable statistics.
    29. EXP-00091: Exporting questionable statistics.
    30. . . exporting table                            EMP         14 rows exported
    31. EXP-00091: Exporting questionable statistics.
    32. EXP-00091: Exporting questionable statistics.
    33. . . exporting table                    EMP_AGGR_MV          3 rows exported
    34. . . exporting table                       SALGRADE          5 rows exported
    35. EXP-00091: Exporting questionable statistics.
    36. . . exporting table                            T01          0 rows exported
    37. EXP-00091: Exporting questionable statistics.
    38. . . exporting table                           TAB1          0 rows exported
    39. EXP-00091: Exporting questionable statistics.
    40. . . exporting table                           TAB2          0 rows exported
    41. EXP-00091: Exporting questionable statistics.
    42. . exporting synonyms
    43. . exporting views
    44. . exporting stored procedures
    45. . exporting operators
    46. . exporting referential integrity constraints
    47. . exporting triggers
    48. . exporting indextypes
    49. . exporting bitmap, functional and extensible indexes
    50. . exporting posttables actions
    51. . exporting materialized views
    52. . exporting snapshot logs
    53. . exporting job queues
    54. . exporting refresh groups and children
    55. . exporting dimensions
    56. . exporting post-schema procedural objects and actions
    57. . exporting statistics
    58. Export terminated successfully with warnings.
    59.  
    60. [1]+  Done                    exp userid=scott/tiger@PDB1 owner=scott log=/home/oracle/expbk/scott.log file=/home/oracle/expbk/exp_pipe
    61. [oracle@oracle-db-19c expbk]$

     

    导入用户数据时，要在数据库中将用户创建好。

    imp scott/tiger@PDB1 file=scott full=y buffer=10000000 log=/home/oracle/expbk/imp_scott.log

    导出表空间：

    exp system/system@PDB1 tablespaces=tbs1 file=/home/oracle/expbk/exp_tbs1.dmp buffer=10000000

  • 相关阅读:
    力扣刷题链表需要调试？一个简单的调试器帮你解决苦恼
    Windows11 环境安装Gradle
    Unity3D教程：手游开发常用排序算法 -上
    LIF-MDF6000-6KMG80I FPGA现场可编程门阵列 封装BGA
    leetcode-06-[454]四数相加II[383]赎金信 [15] 三数之和 [18] 四数之和
    SqlBoy:异或、交换奇偶
    Redis - 高级
    【性能测试】JMeter：集合点，同步定时器的应用实例！
    STM32实战总结：HAL之触摸按键
    前端：nodejs多版本管理工具nvm
  • 原文地址：https://blog.csdn.net/u011868279/article/details/128195126