Skip to main content
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
Search options not deleted user 48583

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.

1 vote

Which version is the right one to begin with Oracle

Start here: 11G 2 Day DBA Best of luck!
mmmmmpie's user avatar
  • 220
1 vote

opening_database

Your database isn't open. Open it using the below command. alter database open;
mmmmmpie's user avatar
  • 220
2 votes

Create a test enviroment in Oracle 10g

This can be achieved with the expdp CONTENT flag: expdp username/password DIRECTORY=directory_object_name \ DUMPFILE=dumpfile_name \ TABLES=table_nam …
mmmmmpie's user avatar
  • 220
0 votes

ORA-01410 Error

ORA-06512 is a catch all for PL/SQL errors. The one you need to be concerned about is the ORA-01410 (more than likely a cause/effect here). What is your DB version? Run this: select * from v$database …
mmmmmpie's user avatar
  • 220
1 vote

my oracle db won't open please help

If this is an environment you or anyone else cares about I recommend: 1) Opening an Oracle service request 2) Find your organizations DBA and engage them immediately 3) Dig those backups out because you …
mmmmmpie's user avatar
  • 220
6 votes

Allowing users to compile / run PLSQL and SQL

I think as a DBA you will inevitably lose the fight to keep hands out of your database. Having said that I think we owe it to our customers to try and provide a product that they can use. There are da …
mmmmmpie's user avatar
  • 220
1 vote

parsing and purpose of oracle audit (.aud) logs

Session_Id>108802</Session_Id> <StatementId>9</StatementId> <EntryId>1</EntryId> <Extended_Timestamp>2005-10-09T00:20:02.284327</Extended_Timestamp> <DB_User>SCOTT</DB_User> <OS_User>oracle
mmmmmpie's user avatar
  • 220