urgent question,please help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: urgent question,please help

  1. #1
    Join Date
    Jun 2001
    Posts
    193
    say under account test1. i have three tables
    tableA,tableB,tableC.

    and at the same database, i have another user account test2.
    i want to copy tableA,tableB,tableC from test1 to test2.
    there may be lots of user modifing the table.
    i want to copy it over at the same point of time.
    what should i do?

    let's say test1's tableA have record 1
    tableB have record 1 , tableC have record 1.

    my questin is:
    say if i
    create table testA as select * from test1.testA
    create table testB as select * from test1.testB
    create table testC as select * from test1.testC

    then maybe right after i create table testA.
    somebody may insert a new record 2 in TableB.

    what i want to copy is 1 for tableA,1 for tableB and 1 for tableC
    instead of 1 for tableA, 1 and 2 for TableB, 1 for TableC.

    am i clear?
    guru is on the way!!!!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Export with consistent=y and then import with fromuser=usera touser=userb
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. create tables empty
    2. start a transaction
    3. insert into table1
    4. insert into table2
    5. insert into table3
    6. commit
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width