Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
what 's the diffrent between offline and offline drop

what 's the diffrent between offline and offline drop

2004-12-27       - By Alex

Reply:     1     2     3     4  

SGkgb3JhY2xlLWwNCg0KaSBkaWQgYSB0ZXN0IGFib3V0ICdhbHRlciBkYXRhYmFzZSBkYXRhZmls
ZSB4eHggb2ZmbGluZSAoZHJvcCknDQppdCBzZWVtcyBmb3IgdGhlIGVuZCB1c2VyLCB0aGVyZSBp
cyBubyBkaWZmcmVudC4gaSBjYW4gcmVjb3ZlciB0aGUgZGF0YWZpbGUgYW5kIHRha2UgdGhlIGRh
dGFmaWxlIG9ubGluZSBldmVuIGkgb2ZmbGluZSBkcm9wIHRoZSBkYXRhZmlsZS4NCg0KU1FMPiBz
ZWxlY3QgKiBmcm9tIHYkdmVyc2lvbjsNCg0KQkFOTkVSDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpPcmFjbGU4aSBFbnRl
cnByaXNlIEVkaXRpb24gUmVsZWFzZSA4LjEuNy4wLjAgLSBQcm9kdWN0aW9uDQpQTC9TUUwgUmVs
ZWFzZSA4LjEuNy4wLjAgLSBQcm9kdWN0aW9uDQpDT1JFICAgIDguMS43LjAuMCAgICAgICBQcm9k
dWN0aW9uDQpUTlMgZm9yIDMyLWJpdCBXaW5kb3dzOiBWZXJzaW9uIDguMS43LjAuMCAtIFByb2R1
Y3Rpb24NCk5MU1JUTCBWZXJzaW9uIDMuNC4xLjAuMCAtIFByb2R1Y3Rpb24NCg0KU1FMPiBzZWxl
Y3QgbmFtZSBmcm9tIHYkZGF0YWZpbGU7DQoNCk5BTUUNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
DQpDOlxPUkFDTEVcT1JBREFUQVxBTEVYXFNZU1RFTTAxLkRCRg0KQzpcT1JBQ0xFXE9SQURBVEFc
QUxFWFxSQlMwMS5EQkYNCkM6XE9SQUNMRVxPUkFEQVRBXEFMRVhcVVNFUlMwMS5EQkYNCkM6XE9S
QUNMRVxPUkFEQVRBXEFMRVhcVEVNUDAxLkRCRg0KQzpcT1JBQ0xFXE9SQURBVEFcQUxFWFxUT09M
UzAxLkRCRg0KQzpcT1JBQ0xFXE9SQURBVEFcQUxFWFxJTkRYMDEuREJGDQoNCjYgcm93cyBzZWxl
Y3RlZC4NCg0KU1FMPiBhbHRlciBkYXRhYmFzZSBkYXRhZmlsZSAnQzpcT1JBQ0xFXE9SQURBVEFc
QUxFWFxUT09MUzAxLkRCRicgb2ZmbGluZTsNCg0KRGF0YWJhc2UgYWx0ZXJlZC4NCg0KU1FMPiBh
bHRlciBkYXRhYmFzZSBkYXRhZmlsZSAnQzpcT1JBQ0xFXE9SQURBVEFcQUxFWFxUT09MUzAxLkRC
Ricgb25saW5lOw0KYWx0ZXIgZGF0YWJhc2UgZGF0YWZpbGUgJ0M6XE9SQUNMRVxPUkFEQVRBXEFM
RVhcVE9PTFMwMS5EQkYnIG9ubGluZQ0KKg0KRVJST1IgYXQgbGluZSAxOg0KT1JBLTAxMTEzOiBm
aWxlIDUgbmVlZHMgbWVkaWEgcmVjb3ZlcnkNCk9SQS0wMTExMDogZGF0YSBmaWxlIDU6ICdDOlxP
UkFDTEVcT1JBREFUQVxBTEVYXFRPT0xTMDEuREJGJw0KDQoNClNRTD4gcmVjb3ZlciBkYXRhZmls
ZSAnQzpcT1JBQ0xFXE9SQURBVEFcQUxFWFxUT09MUzAxLkRCRic7DQpNZWRpYSByZWNvdmVyeSBj
b21wbGV0ZS4NClNRTD4gYWx0ZXIgZGF0YWJhc2UgZGF0YWZpbGUgJ0M6XE9SQUNMRVxPUkFEQVRB
XEFMRVhcVE9PTFMwMS5EQkYnIG9ubGluZTsNCg0KRGF0YWJhc2UgYWx0ZXJlZC4NCg0KU1FMPg0K
U1FMPiBhbHRlciBkYXRhYmFzZSBkYXRhZmlsZSAnQzpcT1JBQ0xFXE9SQURBVEFcQUxFWFxUT09M
UzAxLkRCRicgb2ZmbGluZSBkcm9wOw0KDQpEYXRhYmFzZSBhbHRlcmVkLg0KDQpTUUw+IGFsdGVy
IGRhdGFiYXNlIGRhdGFmaWxlICdDOlxPUkFDTEVcT1JBREFUQVxBTEVYXFRPT0xTMDEuREJGJyBv
bmxpbmU7DQphbHRlciBkYXRhYmFzZSBkYXRhZmlsZSAnQzpcT1JBQ0xFXE9SQURBVEFcQUxFWFxU
T09MUzAxLkRCRicgb25saW5lDQoqDQpFUlJPUiBhdCBsaW5lIDE6DQpPUkEtMDExMTM6IGZpbGUg
NSBuZWVkcyBtZWRpYSByZWNvdmVyeQ0KT1JBLTAxMTEwOiBkYXRhIGZpbGUgNTogJ0M6XE9SQUNM
RVxPUkFEQVRBXEFMRVhcVE9PTFMwMS5EQkYnDQoNCg0KU1FMPiByZWNvdmVyIGRhdGFmaWxlICdD
OlxPUkFDTEVcT1JBREFUQVxBTEVYXFRPT0xTMDEuREJGJzsNCk1lZGlhIHJlY292ZXJ5IGNvbXBs
ZXRlLg0KU1FMPiBhbHRlciBkYXRhYmFzZSBkYXRhZmlsZSAnQzpcT1JBQ0xFXE9SQURBVEFcQUxF
WFxUT09MUzAxLkRCRicgb25saW5lOw0KDQpEYXRhYmFzZSBhbHRlcmVkLg0KDQoNCqGhoaGhoaGh
oaGhoaGhCSAgVGhhbmtzDQogCQkJCUFsZXgNCg0KoaGhoaGhoaGhoaGhoaGhoXRlY2hfYUAxMjYu
Y29tDQqhoaGhoaGhoaGhoaGhoaGhoaGhoTIwMDQtMTItMjQNCg==


--
http://www.freelists.org/webpage/oracle-l