meta user
network profile
| bio | website | datajini.com |
|---|---|---|
| location | Frösön, Sweden | |
| age | 40 | |
| visits | member for | 10 months |
| seen | 57 mins ago | |
| stats | profile views | 54 |
I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.
|
May 16 |
comment |
Tablespace on ephemeral storage Great question! One can certainly take a tablespace offline, see docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm But I suspect the easiest way to automate this would be to drop the tablespaces before shutting down the Oracle instance. Then there's the issue of what would happen on a machine crash. I'm more of a "logical DBA" so I'll leave it to a "physical DBA" to answer this question. |
|
May 8 |
comment |
Restrict access for Windows administrator in PostgreSQL So the answer is no. The Windows administrator on the machine that Postgres (or any software) is installed on can do anything to the installed software and thereby get access. |
|
May 7 |
comment |
Oracle 10XE: Stop schemas seeing the all_users table? A bit expensive to host too, as Oracle XE's license limits you to one instance per "server"... see docs.oracle.com/cd/B25329_01/doc/license.102/b25456/… |
|
May 7 |
comment |
How to design this database to avoid cyclic dependency? NB The relational model supports doing two inserts or updates as one atomic operation, it's a real shame this isn't supported in SQL (as deferred constraints -- even though I suggested them -- are quite horrible). |
|
May 6 |
comment |
Oracle Connection Manager cman.ora startup Does this help? docs.oracle.com/cd/E11882_01/network.112/e10836/… |
|
May 6 |
comment |
How to design this database to avoid cyclic dependency? You could always used deferred constraints if your DBMS supports them. |
|
May 3 |
comment |
What's the best way to backup DB files via network on Linux and Solaris machines? NB Also configure rman to backup your controlfile to the flash recover area! |
|
May 3 |
comment |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly If it's only after each login in SQL*Plus then the most logical place it's happening is in glogin.sql or login.sql (as haki mentions in his answer). See also adp-gmbh.ch/ora/sqlplus/login.html |
|
May 2 |
comment |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly What do you mean randomly? After login? Or on each login? |
|
May 2 |
comment |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly When is it changing automatically? |
|
May 1 |
comment |
Oracle Connection Manager Configuration I presume also this is just a test environment where all the machines are on the same subnet and that in the production environment you will actually need connection manager? |
|
May 1 |
comment |
Oracle Connection Manager Configuration Why do you have protocol=SPX in your init.ora? |
|
May 1 |
comment |
Oracle Connection Manager Configuration There are several issues with your configuration. 1) your client shouldn't be configured to connect directly to the database. 2) source_route shouldn't be configured 3) you seem to be confusing SIDs and service_names. |
|
May 1 |
comment |
Windows Server 2008 R2, Active Directory, and Oracle Database Server What about your network configuration requires an Oracle proxy server? |
|
May 1 |
comment |
How to load the Adventureworks database into Oracle? Did you try asking sqlzoo.qa@gmail.com about it? |
|
Apr 30 |
comment |
Why does DBMS_UTILITY.COMPILE_SCHEMA break function-based indexes? Good point. And don't forget that more complex expressions (of built-in functions) can also be used in a function-based index -- it doesn't have to be a single function call. |
|
Apr 29 |
comment |
Windows Server 2008 R2, Active Directory, and Oracle Database Server For TNSNAME resolution, I would make one canonical set of sqlnet.ora, tnsnames.ora and put it on a network share. Add TNSADMIN=\\path\to\share in the registry of all Oracle homes on all clients. It's a simple, effective solution dating from the 1990's that still works today. |
|
Apr 29 |
comment |
Windows Server 2008 R2, Active Directory, and Oracle Database Server Or do you just want to use AD for TNSNAMES lookup? This is possible but based on my experience I don't recommend it for anything but the largest of setups. |
|
Apr 29 |
comment |
Why does DBMS_UTILITY.COMPILE_SCHEMA break function-based indexes? Possibly, but in general for a user-defined function used in a function-based index the above holds. |
|
Apr 29 |
comment |
Why does DBMS_UTILITY.COMPILE_SCHEMA break function-based indexes? An index isn't a compiled object like a stored procedure. You (re)build an index, not (re)compile it. |
