It depends on your reason for partitioning -- if you mean to drop a partition in
the future (to roll off the 1999 data or whatever) then the ID range is
potentially a valid approach, as long as ID is serial. If you just want to put
chunks on different disk volumes, you could use the type or even
Create View statement?
Randy
-Original Message-
Sent: Tuesday, September 10, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: using obfuscation
File: Card for Don Jerman What about...
create view my_data as select de_encrypt(sensitive_data
What about...
create view my_data as select de_encrypt(sensitive_data) as
clear_sensitive_data where
sensitive_data = encrypt('CLEAR TEXT') ?
This lets you create an index on the sensitive data without decrypting it, and
the function need only be called once on the clear text.
Caveat: no idea
how about
select tab1.id from tab1,tab2 where tab1.id=tab2.id group by tab1.id having
sum(decode(tab2.status,'Y',1,'N',-1,0)) 0;
Harvinder Singh wrote:
Hi,
we have 2 tables tab1 and tab2 each having id column and tab2 also has column status
that will contain value 'Y' or 'N'
for
...
If the developpers are still tweaking the process, and the requirements
still evolving, it means that they are still in a test phase.
If they are still in a test phase, they shouldn't use production files but
test files...smaller files.
Don Jerman [EMAIL PROTECTED]@fatcity.com on 2002-08-01
Oracle Lite is designed to do this -- the content-deployment part for
standalone applications is a little buggy, but the data deployment and
web-app deployment seems to work. We're instituting a couple of
applications with this now, and data sync seems to be working fine.
Application sync has
are working with a deployable version, I mean a
bunch of users go away with their server/database and
come back 2-3 months after, then they synchronized the
master database.
--- Don Jerman [EMAIL PROTECTED] a écrit :
Oracle Lite is designed to do this -- the
content-deployment part
Light works with a 9ias application (part of the Light package) to establish
the mobile database and application on the mobile client. Once the
application and database are downloaded, the database uses Advanced
Replication to sync with the master when the clients are brought back to the
I have a data conversion team working on our financial data,
prepping it for load into SAP. My concept for the conversion
process was to download the flat files, run programs written in C
or Perl to transform the data, then use SQL*Loader to load them
into relational tables for constraint
My understanding is according to design it should do it automatically. My
experience is it does, sort of. But the app has to be multi-threaded (by the OS
definition, not just context-mapped like Java green threads) for it to ever use
more than one processor at the same time. If your
That's kind of the point -- in an LMT the free space is managed by bitmap. If
it's contiguous in the bitmap it's contiguous, so if you free two adjacent
blocks then they're already coalesced, nothing for SMON to do. That's their
advantage -- no overhead for coalesce and no overhead for creating
If the person's account is a member of the local NT group ORA_DBA they should be
able to follow this procedure from the server console:
- set ORACLE_SID=SID
- sqlplus /nolog
- connect internal/internal_password
I've had 8.1.5 ignore incorrect or missing passwords when I use this feature so
I
%SYSTEMROOT%\system32\drivers\etc\services
However, I'm not sure if the OS pays as much attention to this file as unix
systems do.
Seema Singh wrote:
I want to know which file is equivalent in WIN2000 to /etc/services in unix.
From: Rodd Holman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Last I checked the license that comes with Enterprise Edition was free solely
for the purpose of implementing Oracle services such as Portal, naming and
database logins. If you want to use it for anything other than support of
the included Oracle software, you have to pay extra. IIRC full use
As I impose order on our servers, (moving from project-managed to dba-managed
db's) I perform this sort of task for individual schemas. The short form is the
same as yours except:
3.5) create schemas where tables or tablespace assignments will change.
4.5) create tables that are to have storage
See ch. 10 of the PL/SQL programmers guide -- external procedures.
Summary: someone needs to write a DLL that executes the external program,
then Oracle can call the function from the DLL from a PL/SQL procedure.
I've never had the nerve to put that in a procedure, however, but the
context
JDeveloper may not have installed in the same oracle home as your regular
Oracle client, first see if you have more than one Oracle home directory
on your computer, either by checking the registry under
HKEY_LOCAL_MACHINE/Software/Oracle or by searching for the TNSNAMES.ORA
file. Then ensure
Keep an eye on free memory -- one of our similar systems has to be restarted
every 60 days to prevent the behaviour you're encountering. We haven't
determined the source of the memory leak, but if we permit it to continue
eventually the DB stops responding and cannot be shut down. This system
You should consider running MTS or buying more RAM (if you want to run MTS you
probably need to get to 8.1.7.2 first -- I don't remember its status as of 7.3.4
but in the 8.0 and 8.1.pre-7 series it appears to be unreliable).
Your problem is probably this: of the 1.7G RAM you really only have
I must be going blind -- I search for the patch and the latest I find is 8.1.7.0.2 ...
could you provide the ID number and/or a working
method to find the .1.1 patch for NT?
The Oracle DBA wrote:
I guess you are not on NT because the .1.1 patch is there. The std procedure for 817
is to
Don't forget breaking up common industry design standards like incompatible
data requirements for Kerberos implementations and the use of the latest COM+
for all IPC -- you know -- the ones that require you to buy and run Microsoft
products ;-).
David Messer wrote:
Sounds like MS is afraid
My experience is that 9iAS requires 1G RAM to run well. More if you want
IFS... Given that the typical inexpensive Intel box is capped at 4GB and
Microsoft won't let you use more than 3GB (2.5 realistically) on a 4GB machine,
or half of your real RAM if you have less than 4GB, and that a
And I'm just in the mood for a ramble, too...
We stayed with NT too, because we have the sysadmins and engineers already. I
have a DB that sounds a lot like yours and it's running just fine on a dual p400
with a mirror for redo and archive log and a raid5 for the data files. The real
problem
There's someone in Charlotte, too (dbBasics I believe) but we never use
them as all our programmers are in Raleigh. I've seen some basic-level
classes float through the universities and tech schools, but I wouldn't
recommend them for non-students. Someone at Global keeps after me, too,
but they
Try turning off DHCP when off the network -- set up a bogus net address
like 10.0.0.1 or something and Oracle will happily talk to itself. TNS
bombs because DHCP (actually TCP/IP) reports no address.
Leslie Lu wrote:
Hi all,
I installed 815 EE on NT 4.0 on a laptop and created a
testing
If you created it using the Database Assistant, it created a bunch of strangely
small data files with autoextend turned on. When the file autoextends, it grabs
the next free hunk of disk, of whatever size you set it to grab. Whether
something else is creating ephemeral files that cause these
The disk packs (probably still) come with 60 day trials for everything you
didn't buy.
Alternatively, if you have 10 developers, you could buy a 15-user license for
your developer test machine (10 devs + you, your assistant, your operator and
a couple spares in case you expand). The software
You need to add
FROMUSER=TEDDY
TOUSER=TEDDY
to your parameter file and try again.
[EMAIL PROTECTED] wrote:
Hi guys,
1. In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
2. I run the catexp.sql using
For the Oracle database to -run- the OracleServiceTEST (created with the
oradim80 command below) must be running, so I infer that you're missing the
OracleStartTEST service.
You can try:
oradim80 -edit -sid SID -intpwd PASSWORD -startmode AUTO -pfile
PATH/initSID.ora
and that might create it,
If you're not archiving anyway the NOLOGGING option on import and index creation
might help things go faster (esp. if it's all on the same drive). Don't turn it
on for the import if you're appending to existing data (unless you like living
dangerously) but for indexes it's a good option for
We're struggling with iAS/ iFS now with a similar box (only it's a leftover quad 400,
2GB mem from an appserver upgrade), could you elaborate on the "TWICE" part?
"Jesse, Rich" wrote:
Hi Patrice,
I've successfully installed OEM 2.2 *TWICE* (thanks to Oracle Support for
telling me that it
Last time I danced with our sales rep, power units were per server, not per
user... so the power unit price would be 400*100 = 40,000 for an unlimited (Ha!
at 200mhz?) number of users. If you ask nicely, yours may agree to convert any
concurrent or named user licenses you have into power unit
Last time I danced with this topic (8.1.5), BFILE required the file to
exist somewhere accessable to the data server (like on a mounted file system)
that you create an alias for with CREATE DIRECTORY. But the data
server could not create or write the file. So you have to let the
application
Been there -- I don't know about availability, but this is what we have to
do for people working at home through their ISP. I'm assuming NAT
produces similar problems. You can use CMAN for firewall tunnelling with
or without MTS, don't know about connection concentration, though, as we
don't
Something like:
create table keys(
key_id char(8) primary key,
key_val raw(128) not null);
where key_id is rawtohex(the 32-bit key id) and key_val is the 1024bit
key... although it's technically feasable to generate duplicate key id's
(especially with this sample size) it's probably not good
See www.lokigames.com
Try Heavy Gear II and Quake III...they run well on my box.
Kevin Kostyszyn wrote:
What about Mechwarrior or Quake II, can I run that on Unix and will it run
smoothly? This is a fun debate, but I do agree there will never be a
winner.
-Original Message-
When you say "no natural key" I assume you mean no data that is non-null
and unique. How, then, do you propose to get single records, since you
(probably) don't want to have to find them by the image data...
Of course, if the table is write-only -- who cares? :-)
Brian Wisniewski wrote:
I
37 matches
Mail list logo