Allen's profileLi's spacePhotosBlog Tools Help

Blog


    June 24

    将oracle中的一个表空间表STP_A数据 导入到另一个表空间STP_B的方法

    1、通过exp命令(用户:stp_a_user),将STP_A导出数据,导出数据文件为STP_A.dmp
        exp 用户名/密码@Oracle数据库连接字符串 file=STP_A.dmp

    2、通过imp命令(用户:stp_a_user),将STP_A.dmp导入数据,指定参数INDEXFILE生成脚本文件STP_A.SQL(表创建SQL语句、INDEX等创建SQL语句);
        imp 用户名/密码@Oracle数据库连接字符串 file=STP_A.dmp INDEXFILE=STP_A.SQL

    3、通过ULtraEdit将STP_A.SQL文件进行整理:
        将原数据表空间名替换为新表空间名;
        去掉... * rows(通过正则表达式替换);
        去掉REM (通过一般替换字符);

        另存为STP_B.SQL。

    4、通过管理员,创建STP_B表空间及指定的用户stp_b_user;

    5、执行STP_B.SQL文件中的SQL语句,创建表等(用户:stp_b_user);

    6、通过imp命令(用户:stp_b_user),将STP_A.dmp的数据进行导入,导入时指定Ingore为y则可导入数据。

    Comments

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Trackbacks

    The trackback URL for this entry is:
    http://lislog.spaces.live.com/blog/cns!29F76575168CBBB9!253.trak
    Weblogs that reference this entry
    • None