-
as seen on Server Fault
- Search for 'Server Fault'
When I rut the following:
set ORACLE_SID=orcl
exp.exe 'SYS/system as sysdba' full=y log=exp.log file=mydump.dmp
in the end i see the following:
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
what should i do to resolve…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi Following is the syntax for creating table in mysql.
I want to create table with same properties in oracle9i.
Can anyone provide me the equivalent syntax for oracle?
CREATE TABLE IF NOT EXISTS "tbl_audit_trail" (
"id" int(11) unsigned NOT NULL,
"old_value" text NOT NULL,
…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I've a cube olap created with oracle9i, and I want to do some queries on this cube using a java application, but the problem is: how can I connect the java application with the cube olap.
thanks for your help
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I am in a development environment, and our test Oracle 9i server has been misbehaving for a few days now. What happens is that we have our JDBC connections disconnecting after a few successful connections.
We got this box set up by our IT department and handed over to. It is 'our problem', so options…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Getting this error when executing SQL Server query only when connected via remote Desktop.
When running the query from desktop, no problem. Is this a tsnNames issue?
Linked server to Oracle 9i
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider…
>>> More
