Hot answers tagged oracle
5
Note: Deletes perform normal DML. That is, they take locks on rows, they generate redo (lots of it), and they require segments in the UNDO tablespace. Deletes clear records out of blocks carefully. If a mistake is made a rollback can be issued to restore the records prior to a commit. A delete does not relinquish segment space thus a table in which all ...
4
The short answer: you cannot add column to a table at a specific position.
When you add new columns they always go after the existing columns. You have to re-create your table with new definition to place a column to a position you need.
You can however create views with columns positioned arbitrarily based on your existing table, and then query or update ...
4
Toad cannot directly read Oracle data files, no. You would need to recover the database on a local server. Once you do that, you could connect to Oracle database on the local server from Toad and run whatever queries you'd like.
Assuming that what you've been given is a consistent cold backup of your database, you'd need, at a minimum, exactly the same ...
2
RMAN only works at the block level & has no idea about the contents of a given block, and therefore cannot do this.
You need to use expdp with the query parameter:
expdp phil/phil directory=myexportdir dumpfile=yourtable.dmp query=yourtable:\"where groupid in (1,2,3)\" tables=yourtable
Obviously, this isn't incremental. There's no really easy way of ...
2
No, you don't have to reinstall the Oracle software. According to the section "Oracle Database 11g Release 2 (11.2.0.1) New Features" in the Database Installation Guide 11g Release 2:
Oracle Universal Installer no longer provides the custom installation
option of individual components. Use the chopt tool, a command-line
utility that is located in ...
1
You should use export/import. On your side do:
expdp system/systempawwdord SCHEMAS=YOURSCHEMA
This will produce a file. Take it manually to you customer using CD, DVD, Pendrive. On customer site do:
impdp system/systempassword SCHEMAS=YOURSCHEMA
If the customer is using a different Oracle version, this is not a problem. You probably need to manually ...
1
An Oracle database uses two basic kinds of disk files - .dbf (data) and .ctl (control) files. You can also have .idx files (for indices). In most environments I've been in, these are located in /u01, /u02, /u03, and on, for however many /u0X's your DBAs had created.
On the other hand, many Oracle installations don't use filesystem files, they use raw disk ...
1
Here's an example of how you can do this in shell script (bash or ksh for instance). Here's simple SQL script to test, it turns off (most?) of the usually undesired output from SQL*Plus:
set feedback off
set echo off
set heading off
set pages 0
whenever sqlerror exit 4
whenever oserror exit 8
select status from v$instance;
exit
You can run it like this, ...
1
The latest full client will work fine with 10g.
I have experienced similar problems using anything other than the full client, even though according to Oracle the others should work.
Just make sure that you completely uninstall all elements of the previous installs as having multiple clients/versions can create another set of problems.
1
Log file sync occurs when a commit is made and the redo buffer needs to be flushed to disk. The session has to wait for that to happen.
An increase in the number of log file syncs generally means that one of your developers has gone commit-happy, and is committing far too frequently -- every row, for example.
Here you probably have a process that performs ...
1
The best source for Oracle internals is generally the Oracle Concepts Guide.
In this case they have a pretty good description, including how it works as part of transaction control.
http://docs.oracle.com/cd/E11882_01/server.112/e25789/transact.htm#CNCPT039
1
According to the Glossary from the Oracle Documentation
System Change Number. A database ordering primitive. The value of an SCN is the logical point in time at which changes are made to a database.
There is lots of info you can easily Google
http://oracledbascriptsfromajith.blogspot.com/2009/05/understanding-scnsystem-change-number.html
...
1
@haki has identified why this error occurs. You can't use an alias (KODE) defined in the SELECT list, in the definition of another column in that list. You have to use the full reference instead (ANGGARAN.SIMPEG_PEGAWAI.ID_PEGAWAI).
But the solution provided, does not work I think because of the double nesting. You can reference a column in a inline ...
1
It's a bit scary that you're working on a RAC database but are getting confused between databases and instances.
The database is the set of files that store the data plus the supporting configuration files, and the instance is the set of memory allocations and processes that access them. A RAC system is distinguished by having multiple instances accessing a ...
1
It looks like a new schema in the existing database is the best option. Forget about having more instances on one server, this does not give the optimal performance and utilization. One of the biggest advantages of having schema's for different applications in one database is that Oracle Resource Control can be used to control the workload. In the ideal ...
1
When using one database with two schemas you also share SGA structures(like library cache) and also possibly TEMP tablespace and also backups. In rare cases one application can have negative impact on other's performance. Also if you are asked to revert one schema it will be much harder to "restore" just one schema. The same also applies to patching, it's ...
1
You could use Oracle Data Pump Export and unload data compressing the resulting dump file(s). Below is an example of unloading the tables EMPLOYEES and DEPARTMENTS owned by the user HR:
expdp hr parfile=hrexp.par
The parameter file hrexp.par contains the following parameters:
content=data_only
compression=all
include=table:"IN ('EMPLOYEES', ...
Only top voted, non community-wiki answers of a minimum length are eligible
