问答详情
源自:4-2 Oracle 复制表数据

老师,怎么备份和还原?

备份成dmp文件,讲dmp文件还原

提问者:守护信仰 2017-10-14 14:39

个回答

  • qq_吴奎_0
    2017-10-15 01:34:13

    数据库模式:
    EXP SYSTEM/PASSWD@ORACLE FULL = Y FILE = 'DB081222.DMP' LOG = 'DB081222.LOG'
    用户模式:
    EXP USER/PASSWD@ORACLE FILE = 'USER081222.DMP' LOG = 'USER081222.LOG'
    表模式:
    EXP USER/PASSWD@ORACLE FILE = 'USER081222.DMP' LOG = 'USER081222.LOG' TABLES = ('TABLE_1','TABLE_2')