All Questions
24
questions
-1
votes
1
answer
1k
views
Users and Roles Extraction in Oracle
I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this:
SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM ...
1
vote
1
answer
305
views
Oracle 12c 32-bit client and direct GOT relocation R_386_GOT32 against `lxecerr’
When trying to install Oracle 12c 32-bit Client (12.1 or 12.2) on Oracle Linux 7.3 or 7.5, it throws error during linking static libraries:
INFO: Start output from spawned process:
INFO: -------------...
0
votes
1
answer
292
views
SQL 2008 R2 replication with Oracle DB Server Issue
I am configuring replication between SQL 2008 R2 & Oracle DB server.
Getting below error
"ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
2
votes
1
answer
8k
views
Oracle- Can't access objects from other users schema
I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I ...
2
votes
1
answer
5k
views
How do you read an Oracle .dmp file on a Mac?
I have a ~1GB .dmp file I'd like to get the data out of and I'm on a Mac. Is there any way to do this without either buying Oracle or finding a windows machine?
Can you import .dmp files into ...
6
votes
2
answers
3k
views
My table half-exists. Can't drop it
I have a table that is taking up quite a bit of space even though it has no rows. I also dropped it a while ago. When I try to drop it now, it says the table doesn't exist.
It shows up in user_tables....
4
votes
2
answers
49k
views
oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist
I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried.
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 08:19:...
0
votes
2
answers
8k
views
Howto enable remote login for a Oracle db user?
Stupid question:
I've successfully installed Oracle 11g on my Linux box.
I can connect to it and retrieve the countries table via C#/mono just fine, with the below connectionstring, which uses the ...
1
vote
1
answer
795
views
How to generate test data from an sql query and a result set?
I am using an oracle database and want to generate test data from a live database, but I do not want to
copy the whole database content.
Given a database DB(S, D) consisting of the database schema S (...
0
votes
2
answers
358
views
Error 503 on SQL/Oracle prodécure execution
I'm facing a problem with the Apache/Tomcat/JDBC/Oracle communication configuration of an application.
Here are all the informations I have at my disposal about the problem :
A button on the web-app ...
0
votes
1
answer
349
views
oracle 10g tablespace table relation?
Im running "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" and trying to get familiar with it. I have created a tablespace und set it online. How do I make sure the next create ...
1
vote
1
answer
3k
views
SQL / OracleDB: How to set the same value for all fields in a column?
Is it possible to set a value for all fields in a column, e.g.:
ID Host URI
1 //cyrus /images
2 //cyrus /videos
3 //cyrus /text
4 //cyrus /misc
5 //cyrus /backup
I want be able to change ...
1
vote
0
answers
676
views
Switched Oracle to use Shared Servers, now Java app throws SQLRecoverableExceptions
This issue might blur the line between Java and database problem, so I apologize if this is the wrong place for it. Not sure which side is to blame yet.
I'm a Java developer temporarily playing DBA ...
3
votes
3
answers
211
views
Is there a way to communicate DBMS with raw memory block or binaries
I am trying to communicate a numerical matrix operations library like LAPACK with any DBMS.
Is it possible to send/receive complete matrices as binary or as a direct memory pointers to process them (...
0
votes
2
answers
10k
views
Oracle 11g: Why doesn't "grant create session" allow user to log in?
I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there ...