12,246 reputation
12035
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 9 months
seen 17 hours ago
Oracle ACE

Apr
25
revised Parking Lot table for employees
deleted 17 characters in body; edited tags
Apr
25
comment Parking Lot table for employees
I have grave difficulty of a reasonable way to construct a ParkingSpace table that stores information about 100 spaces using 20 rows of 5 columns each. That goal appears to violate every rule of table construction known to mankind. I assume, therefore, that this is not really what your instructor wants. Columns represent attributes. What attributes of a parking space do you want to capture? Rows represent instances of a thing. If there are 100 parking spaces, you could have 100 rows in your table. Beyond that, though, I'm not sure quite what you're asking.
Apr
24
comment Is there a simple, safe and low cost way to implement a (limited) database to be outside (close) IT control?
I'd start by visiting your company's reporting group to see if they have anything in place that gives them a "sandbox" in which they can build tables to support ad-hoc reporting requests. If they do, you can see if you can get similar access.
Apr
24
answered What are the risks of building a database outside IT control?
Apr
22
comment DISTINCT not using an index
@Sparksis - Does "transactional" imply that this is part of an OLTP system rather than a data warehouse/ DSS sort of system?
Apr
22
comment DISTINCT not using an index
In a comment below, the original poster indicates that this is a "transactional" table. If that means that it is involved in OLTP operations, a bitmap index may not be appropriate both from a locking standpoint and from a growth standpoint.
Apr
17
answered DISTINCT not using an index
Apr
13
comment I'm unable to open a datafile in oracle, looking for a solution
Does the file exist o the file system? It appears that it used to exist and now does not. If that's the case, you're looking at doing a database recovery. Hopefully, the DBA left excellent documentation on how to do that in your environment.
Apr
11
comment Difference between oracle database desktop and server class
Can you describe the network topology a bit? Is your laptop, for example, getting its IP address via DHCP or does it have a static IP address? On the remote machine, are you using the IP address to connect to the Oracle database? Or is the remote client using a host name which is resolved by a DNS server?
Apr
10
comment what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
Did you mean to add this answer to a different question? I'm not sure that I see the relationship to the question...
Apr
10
revised what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
added 725 characters in body
Apr
10
answered what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
Apr
9
comment Importing bulk csv file to oracle database
Does that generate a control file and a command line? Can you post those? What is the database waiting on?
Apr
9
comment Importing bulk csv file to oracle database
What is your control file? What is your command line? Are you doing a direct path load? Are you loading data across the network? Is the file on the client machine or the server? Can it be moved to the server?
Apr
8
comment “Reformat” an Oracle instance
A schema is the collection of objects owned by a user. If you dropped the schema, you would have used the DROP USER command. If there are additional users that you want to drop, you'd need to drop them as well. Maybe you want to drop the entire database and create a new one but that seems excessive if you're really only trying to import a dump file.
Apr
8
comment “Reformat” an Oracle instance
I'm not sure that I understand what you are trying to "clean up". Is it not sufficient to drop whatever schemas you have that you no longer want? Perhaps you want to drop the existing database and create a new one from scratch?
Apr
7
answered Oracle becomes too slow after system crash
Apr
7
comment Revised Question: How do I prevent Oracle 12c Database from starting on machine boot
@Eric - I'm not sure that I understand the question. OracleService<<SID>> is a service. If that service is set to run at startup (which it is by default), it will start the database when the machine starts up. If you change that service to start manually, the database won't start up automatically.
Apr
7
answered Revised Question: How do I prevent Oracle 12c Database from starting on machine boot
Apr
4
revised How to know DB size using backup file without restoring it
edited tags