Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with oracle
Search options not deleted
user 7102
All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.
5
votes
Where to start with Oracle?
I like this one:
Oracle Magazine SQL 101 …
5
votes
Accepted
Oracle newly created DB is filled with datatables
The same applies for the Oracle Database. After creation of an Oracle Database, there will be tons of objects (tables,functions,procedures,indices,packages,etc..) constitute your Oracle Database. … This is exactly what you do in an Oracle Database as well.
An Oracle Database can handle thousands of users and schemas. …
- 672
4
votes
best practice either create multiple databases or multiple users
Oracle has this new pluggable pill in their latest release 12.1.0.1 of the database which is supposed to address the "multiple database vs. multiple schema" discussion. …
- 672
3
votes
Oracle client throwing ORA-12541: TNS:no listener
Please login as oracle user and try these steps.
Set your oracle environment
$ . oraenv # note the dot!
$ <input your SID>
Login and fire up. …
- 672
3
votes
Accepted
Listener.ora Location
Watch out for variable TNS_ADMIN which overrides Oracle default network directory. …
- 672
2
votes
Get tablespace name from dump file
https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm
impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp
SQLFILE=dpump_dir2:expfull.sql
- 672
2
votes
How to fetch file path from a folder through PL/SQL
Mr. Kyte wrote about accessing os-file-information utilizing the preprocessor directive a while ago. Perhaps this is what you are after.
query the operating system
- 672
2
votes
Accepted
Oracle Patching & Database Upgrade - Which Order
This is also what Oracle instructs us to do in for example this document:
http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12394
After you have installed the software for Oracle … Database 11g Release
2 (11.2) and any required patches, Oracle recommends that you analyze
your database before upgrading it to the new release …
- 672
2
votes
ORA-12541: TNS:no listener
My sequence of steps for troubleshooting
Is the listener resolvable? C:\>tnsping MYDB (Confirms: the database listener is running on serverside)
Is there a firewall issue? C:\>telnet hostname 1521 …
- 672
2
votes
Can I do an impdp with a file on my local computer
You need to move the dump-file to an area where the database has access to it referenced inside the database as a directory object. You can run impdp from your local computer.
- 672
2
votes
Accepted
glogin.sql supress error when Instance Idle
This is what I use in my login.sql. Tom Kytes book Expert One on One has this script. No sign of ORA-01034 when instance is down. My prompt only shows idle>
set term off
-- a lot of stuff
REM h …
- 672
2
votes
How to access oracle PDB remotely?
My environment (18c XE docker):
sqlplus "sys/oracle@localhost:1521/XE as sysdba"
sys@XE> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- -------------------------- … sqlplus system/oracle@localhost:1521/cnn-int-prod.cnn.com
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 11 15:21:12 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. …
- 672
2
votes
Is it free to download an Oracle Enterprise Edition image from Docker?
Make sure you accept the Oracle Standard Terms and Restrictions (green checkmark)
Now you are ready for the bash-console! … You will have to download the Oracle Database software and put them into designated folders before executing the build script.
Oracle Database 18c XE is full of EE feature. …
- 672
2
votes
How to get a list of current Oracle CDBs on server
This is how I list running database instances. Container-databases or non-container databases:
cat >> ~/.bash_profile <<EOF
oinst() {
/bin/ps -ef | grep ora_lgw[r] | awk '{print $8}' | sed …
- 672
1
vote
How to organize a development environment using Oracle XE 11g?
Any serious development project involves source control and a deploy process - SCM (Software Configuration Management). Make sure you put all your database objects (table, index, packages etc..) under …
- 672