OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » index & DBlink

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

index & DBlink [message #62280]

Sun, 11 July 2004 12:30

sandeep
Messages: 110
Registered: October 2000

Senior Member

i am inserting one table thru dblink to another database.so is there anyway to separte the index to different tablespace as from the source db

with regards
sandeep

Report message to a moderator

Re: index & DBlink [message #62281 is a reply to message #62280]

Sun, 11 July 2004 16:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the requirement is not clear.
U can always have the index and table in seperate tablespace.

Report message to a moderator

Re: index & DBlink [message #62292 is a reply to message #62281]

Tue, 13 July 2004 01:31

sandeep
Messages: 110
Registered: October 2000

Senior Member

i am transgerin data from
one db to another i have table calleds
sales in sale tablespace and 2 index on sales table
on ind tablespace
when i am transfering rows from this sales table eg
sales db to different db using dblink what will happen
to the realted indexes for that particular sales table
where it will be stored in the remote db or wheter we have to make any statement to move the index to different tablespace

Report message to a moderator

Re: index & DBlink [message #62293 is a reply to message #62292]

Tue, 13 July 2004 03:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

how are u "transfereing the rows"?
the insert into select * from table@dblink will look into data/rows only ( any select will do the same).
the indexes for the table in targetDB should be building locally in targetDB.

Report message to a moderator

Previous Topic:	problem in locating the correct Host String
Next Topic:	Problems when exporting and importing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:31:00 CDT 2024