Recent content by piski

P
Maxtor external keeps disconnecting on firewire but not usb

I have 3 older maxtor external drives. I just bought one of the new maxtor drives and attempted to move a divx movie to it through firewire from my desktop. After about 8 seconds of transfer it pauses and then says it cant copy to the drive. The the new maxtor is disconnected and I have to turn...
- piski
- Thread
- Jan 4, 2005
- Replies: 0
- Forum: Computer Building
P
Comparing dates in Oracle SQL

WHAT IS IT EXACTLY THAT THE DISTINCT KEYWORD DOES?
- piski
- Post #7
- Dec 7, 2004
- Forum: Windows
P
Comparing dates in Oracle SQL

THANKS FOR ALL YOUR HELP
- piski
- Post #6
- Dec 7, 2004
- Forum: Windows
P
Comparing dates in Oracle SQL

I only recieved the error after adding the date function. but here you go: (I have spaced it out a bit for you) CREATE VIEW E_V AS SELECT ORDER_LINE_T.ITEM_ID, ITEM_T.DESCRIPTION,VENDOR_ORDER_T.DATE_RECEIVED,ORDER_TOTAL_V.TOTAL , ORDER_LINE_T.ORDER_NO FROM ORDER_LINE_T...
- piski
- Post #3
- Dec 7, 2004
- Forum: Windows
P
Comparing dates in Oracle SQL

I need to create a view showing orders from 2001 This is the format that my dates were entered into the records with: declaration: date date_ordered; data: '11/SEP/01' So in my where statement I have written: where date_ordered >= '01/jan/01' This should give me only...
- piski
- Thread
- Dec 7, 2004
- Replies: 6
- Forum: Windows
P
ORACLE SQL TROUBLES!!! PLEASE HELP

I am creating a view to show a price list. The price list is to show the total amount of money I have spent on each item. therefore the view is to be grouped by item_id. When I create the view without the group by statement, it works fine but i get 2170 records. So I want to group them When I...
- piski
- Thread
- Dec 6, 2004
- Replies: 1
- Forum: Windows
P
Trouble creating tablespace in SQLplus!!

Here is my code: CREATE TABLESPACE orcl DATAFILE E:\oracle\product\10.1.0\oradata\orcl\orcl.dbf' SIZE 50M DEFAULT STORAGE (initial 500K next 50K pctincrease 0); I checked akk if te paths and the spelling and it keeps telling me that there is an error in line 2. Invalid file name. Is my...
- piski
- Thread
- Nov 16, 2004
- Replies: 2
- Forum: Windows
P
lsass.exe unexpectedly stopped!!! THIS KEEPS HAPPENING

I just installed a fresh copy on xp pro on my partition. After the first time that I installed it it worked fine, then I closed the lid of my laptop, went upstairs, reopened the laptop and this error message comes up saying that lsass.exe has unexpectedly quit citing error code -1073741819. I am...
- piski
- Thread
- Nov 15, 2004
- Replies: 1
- Forum: Operating Systems
P
SQl plus question about multiple primary keys in same table

I have an associative entity table (therefore there are 2 primary keys). In SQLplus, how do i create a table with multpile primary keys? CREATE TABLE tablename( primary_one number(10) PRIMARY KEY ,primary_two number(10) PRIMARY KEY ); ??????? Please help, thanks
- piski
- Thread
- Nov 15, 2004
- Replies: 2
- Forum: Windows
P
Trouble sharing wireless connection

We have a wireless network. There is one computer without a wireless card that is too far away from the router to make a direct link. Therefore I have connected a network cable directly from the closest (wirelessly connected) computer to the computer without wireless. Now, the computer without...
- piski
- Thread
- Nov 1, 2004
- Replies: 1
- Forum: Networking
P
new wireless network. All computers can access each other but 1..what am i missing?

yeah. in the network connections window
- piski
- Post #3
- Aug 24, 2004
- Forum: Networking
P
new wireless network. All computers can access each other but 1..what am i missing?

my desktop and laptop are able to access each other shared folders. my roomates desktop can be seen as a workgroup computer but when I try and access it, it says that I am denied access. I checked to make sure that his windows firewall is turned off and he has no other software firewalls...
- piski
- Thread
- Aug 24, 2004
- Replies: 3
- Forum: Networking
P
Server w/ no cd-rom drive..how do I install software?

here is the list of specs: 1 Sony network file server Pentium IV(4) 1.8GHZ 512MB RAM 180GB 8MB buffer hot swappable hard drive 2 Integrated NIC cards Integrated Video port 2 USB ports 2 PS/2 ports Serial Port
- piski
- Post #6
- Aug 20, 2004
- Forum: Computer Building
P
Server w/ no cd-rom drive..how do I install software?

i didnt know that you could install an OS over a LAN. Would it be something like I put the cd in my computer and then choose the install directory as the server hd?
- piski
- Post #3
- Aug 20, 2004
- Forum: Computer Building
P
Server w/ no cd-rom drive..how do I install software?

I am thinking of buying a filer server that has no cdrom drive. a) will this be too much hastle b)in order to install the OS would I need to take one of the harddrives and put it in my computer in order to install the OS? thanks in advance k
- piski
- Thread
- Aug 20, 2004
- Replies: 5
- Forum: Computer Building

RESOURCES

Top Bottom