oracle-xe

oracle express sytem Invalid Login Credentials

i just installed oracle express, im trying to login at database homepage. trying with user sys and system with the password i gave at the installation but i cant log in. message: Invalid Login Credentials at sql command line trying to connect ora-01017 invalid username/password; logon denied i dont know how to modify the password or jus...

OJB / Oracle XE sql debug-display problem

Hello, I have a Java application, and use OJB as my ORM technology. I have an Oracle XE installation locally to develop against. The problem is when I need to debug a problem, I like looking at the SQL output. Here is an example of SQL I can view through the "Top SQL" interface in Oracle XE: select a_bunch_of_fields from KREW_DOC...

oracle spatial fun exercises?

please help me connect spatials to oracle 10g XE where can i find fun things to do with oracle spatial? ...

Question about oracle xe search query

Hello all, this is my second time using ORACLE xe and Apex. Here is what I'm trying to do .. I'm trying to execute the following query SELECT * FROM EMPLOYEES WHERE JOB_TITLE = 'CLERK' but not from sql command prompt but from gui/apex and here is how- I have created page one with one textfield and one submit button. Now of course I'd...

oracle stored procedures

how can I make oracle procedure with oracle xe, how can I check if input is valid or not? ex: if my input is number and I type in char that procedure prints out something in that case, I've dealt with SQL but not with these kind of procedures? any help is appreciated UPDATE This was a dummy example .. what I meant is to start from the ...

Deleted some Oracle DBF files by mistake - how can I tell Oracle XE to forget about them?

So I accidently deleted some DBF files (only ones specfic to my tablespaces), fortunately I was only just about to start loading data in so have lost nothing, except now can't re-create the tablespaces. If I run: select name from v$datafile; The results include the DBF files that I deleted. I attempted to run a command I found on th...

current_schema cannot be changed through Oracle Express Web Interface

Hi folks I was trying to change the current_scheme of user A (App_User) to user B (Schema_Owner) through Oracle Express Web Interface but failed. I was following Tim Hall's advice: http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php#current_schema_approach Logon as Appl_User through: Oracle Express Interface...

Importing a dmp with partitioned tables into Oracle XE

I've got a schema containing partitioned tables. I can use exp to create a .dmp, but when I import that into Oracle XE, I get errors because Oracle XE doesn't support partitioned tables. How do I get the .dmp imported into Oracle XE? I think pre-creating the tables might do it, but how do I extract the DDL in some automated way to do th...

How to install WE8EBCDIC500 on Oracle XE?

I need to make the "WE8EBCDIC500" character set available in an Oracle XE installation (on my desktop) to import a mainframe-generated file. Running SELECT value FROM v$nls_valid_values WHERE parameter='CHARACTERSET' does not show this character set to be installed and I get KUP-03006: error initializing handle for character set WE8EBC...

Oracle sqlplus instantclient and xe env variables

Hi I'm installing Oracle XE and sqlplus on Oracle Enterprise Linux 5. What environment variables do I need? I think that both require different ORACLE_HOME and LD_LIBRARY_PATH. Thanks ...

Select count() max() Date

I have a table with shifts history along with emp ids. I'm using this query to retrieve a list of employees and their total shifts by specifying the range to count from: SELECT ope_id, count(ope_id) FROM operator_shift WHERE ope_shift_date >=to_date( '01-MAR-10','dd-mon-yy') and ope_shift_date <= to_date('31-MAR-10','dd-mon-yy') GROUP ...

How to correctly set the ORACLE_HOME variable on Ubuntu 9.x?

I have the same problem as listed here: http://stackoverflow.com/questions/52239/oracle-lost-sysdba-password although I did not lose the password, I entered it twice in the configure script originally, and then when I went to login (localhost:8080/apex, password not accepted. I don't have anything in the database, I just want to instal...

Connecting Error to Remote Oracle XE database using ASP.NET

I have installed Oracle XE on my Development machine and it is working fine. Then I installed Oracle XE client on my Test machine which is also working fine and I can access Development PC database from Browser. Now, I want to create an ASP.Net application which can access that Oracle XE database. I tried it too, but it always shows me...

Restore Oracle XE data from *.DBF

Is it possible to restore oracle database from *.DBF files? If yes, then how? I really find it hard to deal with backup and restore things in Oracle compared to SQL Server. I have a backup of the whole oraclexe folder including these files. ...

pro*C in oracle XE

I downloaded the free express edition of oracle, Oracle XE. I couldn't find the pro*c compiler in this edition. I read somewhere that oracle 9i client has pro*C, So I presumed that oracle client for 10g XE should have it too and downloaded it. But to my disappointment, I can't find it there too. :(. Is there a way to download the older o...

Where can I find a list of 'Stop' words for Oracle fulltext search?

I've a client testing the full text (example below) search on a new Oracle UCM site. The random text string they chose to test was 'test only'. Which failed; from my testing it seems 'only' is a reserved word, as it is never returned from a full text search (it is returned from metadata searches). I've spent the morning searching oracl...

Is oracle dropping database oracle XE ?

I'm trying to access the download for oracle XE on windows but it fails with 404 error. Is Oracle leveraging its possession of mysql or is it a temporarily error? ...

Importing ShapeFiles into Oracle XE

Hi, I'm looking to import one of the Shapefiles supplied with the Ordnance Survey Boundary-Line opensource set into Oracle XE. http://data.gov.uk/dataset/os-boundary-line Unfortunately I'm completely unsure how to go about this, despite much Googling. Anyone got any pointers or tips or a link to a guide? Cheers James ...

C# Oracle Database 10g issues

Well, the problem is as follows: I have a WPF Application built using the C#, I have known how to connect to oracle database engine, yet I need some help in it. first, I want to know how to add the server to the connection string ... OleDbConnection conn = new OleDbConnection("provider=MSDAORA;data source=ORCL;user id=SCOTT;password=T...

Getting ORA-12560 with Oracle Express 10g

I started to receive this error while I`m using C# with Oracle 10g. ORA-12560 and I really need to solve it as I`m running out of time on my grad project. ...