lizzzard
asked on
Select into allways 'on default'?
Hi again,
Can I tell sybase where to put my table using select into which creates that table?
Can I tell sybase where to put my table using select into which creates that table?
ASKER
Hi, I think you misunderstood my question. I know how to do a select into, but the problem is that the table always shows up on the default segment. Unless I make a clustered index,ofcourse because that would move the whole table to the segment I define the index on.
The problem here is, that the select into is in a temporary table. I don't want to make an index on it and for some other reasons I don't want it on 'default'.
Regards, Alex
The problem here is, that the select into is in a temporary table. I don't want to make an index on it and for some other reasons I don't want it on 'default'.
Regards, Alex
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,Bret
The method I use now is indeed the select into on default and the creating the clustered index on the desired segment,thus moving the table. The sp_placeobject might be something to look at.
Thanks
The method I use now is indeed the select into on default and the creating the clustered index on the desired segment,thus moving the table. The sp_placeobject might be something to look at.
Thanks
Hi lizzzard,
First u have to set the sp_dboption "select into" true in that database
sp_dboption dbname,"select into",true (syntax)
go
After that u have to run check point in that database
use user1
go
checkpoint
go
Now you can run the following query
Select * into database.dbo.tablename from tablename
go
Example
use user1(database name)
go
Select * into user2.dbo.employee from employee
go
I hope it will help you.
Thanx