8

This part is unusual: ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ This needs to be char-by-char identical every time. I see it ends with a slash here, which is non-standard, and I suspect that you've added it by mistake. Adding a slash will result in "ORACLE not available" in so-called bequeath sqlplus, I've just experimented on my system. Try again ...


8

It's not a bug. This behaviour is expected. If you need to increase the connections, just change the processes limit: SQL> show parameter processes processes integer 150 SQL> alter system set processes = <integer> scope=[...]; SQL> shutdown immediate; SQL> startup; -- Either using pfile or spfile, you'll ...


7

There are two tables you can get this info from. APEX_WORKSPACES and APEX_APPLICATIONS. The schema that these tables reside in depends on the APEX version. By way of example, my vanilla Oracle 11.2 install has them in the APEX_030200 schema. To list: select USERNAME from DBA_USERS where USERNAME like 'APEX%'.


6

NLS_LANG can't be changed from inside a session, however other settings can. You can't change the character set once a database connection has been established (ie: the 2nd part of NLS_LANG), but you can change the language with: alter session set NLS_LANGUAGE=SPANISH ... and the territory with: alter session set NLS_TERRITORY=SPAIN


5

path to data files is included in full dump. No, SIDs don't have to match You may want to add REMAP_DATAFILE option (https://docs.oracle.com/database/121/SUTIL/GUID-7C9DDBED-91AC-4FA2-AB91-1FF214DA89B0.htm#SUTIL926 ) to impdp . Alternatively, you can just pre-create all tablespaces on target database.


5

Oracle Express Edition is free software that can be used even for commercial purpose. What the DBA said is true for Enterprise Edition where some features can not be completely disabled (e.g. Advanced Compression), and it was true for Standard Edition in versions below 11g (e.g. Diagnostic Pack). Express Edition will be fine. For a personal learning/...


4

You have a few options, some of which will make your database unsupportable by Oracle (if you care!) as you need to fiddle with SYS owned objects. The first option is to revoke select privs from everyone: revoke select on all_users from public; Then grant it back to certain users, plus all other internal Oracle users. The 2nd option is to look at the ...


4

The information about database data files and online redo log files along with their paths is stored in the control file(s). The information about the control file path is stored in initialization parameter file (pfile) or in server parameter file (spfile). So if you moved your data files, online redo log files and/or control file(s) you should update the ...


4

Any Oracle licencing questions are ultimately determined by Oracle. It would be hard to incur extra costs but if you could enable these features which are not available by default in 10g/11g Xe you could have an audit issue. The use of partitioned objects internal Java virtual machine (JVM) materialized view query rewrite changing character set on 11.2 ...


3

Sounds like you just want a basic AFTER INSERT trigger. Then you can access the inserted data via :new. Something like: CREATE OR REPLACE TRIGGER insert_data AFTER INSERT ON OWNER.TABLE FOR EACH ROW BEGIN INSERT INTO OWNER.OTHER_TABLE (COL1, COL2, COL3) VALUES (:NEW.COL1, :NEW,COL2, :NEW,COL3) END;


3

What does it mean "no longer needed"? Archive redologs have "only one" usage, they can be applied onto the last full/incremental database backup to recover the database. So you either backup your development database and then you can delete them via RMAN during database backup. Or you do not backup your database and then you can run in NO ARCHIVELOG mode.


3

To disable archive logging entirely you need to connect locally (important bit, or you'll get disconnected) and run sqlplus as DBA: C:\>sqlplus / as sysdba ... and then run: SQL> shutdown immediate; SQL> startup mount; SQL> alter database noarchivelog; SQL> alter database open; Additionally, run this to ckeck whether it's enabled: SQL&...


2

Currently Oracle does not support MacOSX. They did for Tiger but dropped support plans for Apple when they bought SUN Microsystems. If you are willing to install an older version of MacOSX you can install Oracle 10.1.0.5 (fully featured) or 10.2.0.4 (incomplete). For now: forget it. What you can do is run 11g on vmware. I have it running on macs using ...


2

This is very simple and there are many tutorials out there. Here is a sample trigger to demonstrate. create table aaaa ( a number ); create table bbbb ( b number ); create trigger aaaa_aitrig after insert on aaaa for each row begin insert into bbbb values ( :new.a ); end; / In case you were wondering, ":new" is a reference to the newly inserted ...


2

Check this registry key to ensure ORACLE_HOME is configured for the service: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_XE\ORACLE_HOME If that doesn't exist, check here: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE\ORACLE_HOME Also make sure this other key isn't pointing to your old client registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\...


2

You need to take a dump of the source database using DataPump export. Then on the target PC install Oracle XE, and use DataPump import to import the dump taken from your source PC. For details on the DataPump utility, please see the manual: http://docs.oracle.com/cd/E11882_01/server.112/e22490/part_dp.htm There are also various tutorials for this utility ...


2

I haven't tried this but in theory you should be able to: Install the exact same version of the software on the other PC using the same installation options (same directory structure, etc). Shutdown the instance on the original PC. Copy all the files from the original PC to the same location on the other PC. Start the instance on the other PC. This should ...


2

In APEX 4, the following are defaults: WORKSPACE = INTERNAL USER = ADMIN


2

when you are installing oracle database you can install all oracle example schemas like scott, HR, oe ... you can install these in step "Specify Database Config Details".click the last tab page "Sample Schemas" then check the check box "create database with sample schemas" as displayed bellow in screenshot. if you already installed database you can ...


2

Yes, you can change NLS_LANG on server and session level. Changing database characterset is almost impossible when the original characterset is not US7ASCII. To change NLS_LANG: Environment variable NLS_LANG System environment variable NLS_LANG Use registry HKLM\software\oracle... and add string value. Remember to use quoting when necessary on Windows ...


2

This version of Oracle XE is based on 11g2 edition, which is not compatible with CentOS 7. In fact, it isn't even 100% compatible with CentOS 6, however it will run there without problems, after you install a number of RPM packages not installed/required by Oracle installer (especially libaio both 32/64-bit). These are formal OS requirements for XE 11g2: ...


2

In SQL*Plus, you can change the pagesize SQL> set pagesize 100 will repeat the headings every 100 rows rather than every 15. You can set the pagesize value to (just about) whatever you'd like. If you want to ensure that the headers are only written once, you can set it to a number much greater than the number of rows that the query will return.


2

In case of expdp/impdp backup impdp ... CONTENT=METADATA_ONLY This will import only the DB objects, but no data. Should you require some data, you can get them for example on table, tablespace, or schema level: impdp ... CONTENT=DATA_ONLY TABLES=my_table,my_table_2... impdp ... CONTENT=DATA_ONLY TABLESPACES=tablespace_1,tablespace_2... impdp ... CONTENT=...


2

There is no such one command to do this kind of migration of a schema because as you mentioned, Oracle Express edition doesn't support all the features that are used in the Enterprise edition. However, I tried to collect some of the useful parameters which can be used during expdp/impdp to modify or include/exclude (un)wanted objects and features. ...


2

The following will generate a list showing the current date, and the warning and due dates for the current date. CREATE TABLE myCal (CAL_Date date, Bus_Working_Day int) INSERT INTO myCal SELECT DATE '2017-06-27', 1 FROM DUAL UNION ALL SELECT DATE '2017-06-28', 1 FROM DUAL UNION ALL SELECT DATE '2017-06-29', 1 FROM DUAL UNION ALL SELECT DATE '2017-06-30', 1 ...


2

Not an Oracle error. Sure you can put the above variables in .bash_profile of oracle, but when you use sudo like above, that will not be executed. [root@o71 ~]# tail -3 /home/oracle/.bash_profile export ORACLE_HOME=/u01/app/oracle/product/dbhome_1 export ORACLE_SID=ETALON export PATH=$ORACLE_HOME/bin:$PATH [root@o71 ~]# sudo -u oracle sqlplus / as sysdba ...


2

Licensing Restrictions Oracle Database XE restricts itself to only one installation per logical environment. The logical environment can either be a virtual host such as a VM or container, or a physical host. If more than one Oracle Database XE installation is attempted to be started in such a logical environment, an "ORA-00442: Oracle Database ...


2

As explained in this answer on SO, if you create a user (or any other identifier) in lowercase, you will have to always quote it when referencing, because by default Oracle (and other SQL databases, except may be Postgres) will convert unquoted identifiers to uppercase. connect "vbk"/password or ALTER USER "vbk" IDENTIFIED BY xxx;


1

As you discovered by yourself, RECOVER is just the process of applying logs . Since corruption occurs at physical level, you must restore the affected datafiles from a backup taken BEFORE the corruption occurs. RESTORE rebuilds the physical attributes of the datafile, so, any physical corruption (eg. disk failure) will be fixed.


Only top voted, non community-wiki answers of a minimum length are eligible