Why would be intensive ?
When I add row to maintable DB engine check if value in the "City" column
exist in the view. If exist - do nothing. If no - add value to the view.
But with deletion we must check existance any other row
with same "City" and delete city from view only when no row
with...
I know about "select distinct". But it is VERY resource consumption action.
Of course, I may make "view functionality" by myself with two tables
and foreign key, but it's DB's duty I mean.
Hi!
(I am very novice in MySQL)
Is it possible create view(virtual table?) from distinct values of main tables ? Or I always must create two real tables with foreign key ?
Example :
I have main table:
ID| Name| City
1 | Ivan | Moscow
2 | Dmitry | Moscow
3 | John | New York
Can I have...
No, no, no (perhaps my english so bad ?)
I don't want use CD ! I want use DVD.
And I don't want use "WebStart" or "Jump start"
I want use Solaris Interactive Installation Program ( CLI ) :
http://docs.sun.com/db/doc/816-2411/6m8ou8s7c?a=view
Have you see difference ?
I have no mouse, keyb...
Hi!
We bought V440 server and got Solaris8 box with it.
In that box threre are one DVD and many CD with OS Solaris8
and other additional software.
Previously I always install Solaris from Solaris 8 Software 1 of 2 CD
with CLI setup program. But whet I do "boot cdrom" from DVD
I always get...
Yes, I have firewall CheckPoint (moreover - with NAT) in the middle.
I seem you made a right guess wallace88.
But very strange - when I twice made by hand
"savegrp -v [-l level] -G group_name"
/bigsaveset saved once each time.
What may be with firewall ?
It is really saved twice - always with big saveset.
I have some clients with big savesets and this happened
on each of them.
I am sure that it is not index problem - it also
happened on just installed server on first backup.
With 2-3 Gb savesets on same client everything OK..
Anybody has...
I have next strange legato behaviour - big savesets with full backup saved twice.
Although small savesets (~<10Gb) on this client saved once.
This happened both 6.0 and 6.1.
03/26/04 11:47:38 nsrd: client:/bigvolume saving to pool 'ClientPool' (device01)
03/26/04 13:29:22 nsrd...
I have 2Tb IDE -> SCSI RAID connected to solaris/sparc8
with legato network edition 6.1
Initially I want create many volumes with size ~20-30Gb (like
DD3 tapes which I used before). But (thanks 605) then I find out
that my network edition support only 16 devices. So I want create
16 big volumes...
HI!
I have 6.1 backup server. I created ~50 file devices
without restarting server and long time work with them.
But when I reboot server it didn't started and hang on
nsrlmc. And in daemon.log next:
00/00/04 10:10:08 nsrd: server notice: started
00/00/04 10:12:00 nsrmmdbd: media db is cross...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.