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...
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...
please help me connect spatials to oracle 10g XE where can i find fun things to do with oracle spatial? ...
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...
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 ...
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...
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...
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...
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...
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 ...
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 ...
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...
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...
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. ...
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...
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...
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? ...
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 ...
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...
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. ...