Tag Info

New answers tagged

0

Here's what worked, although I don't know if it's a good answer or not. I had someone who could log in as an admin on my pc do the Oracle client install. In other words, if you're not a full admin on your machine, it may fail, and not tell you why. I had admin rights, I could edit the registry and path, but there were still some missing rights. Logging ...


0

Delete all your Oracle Clients from machine and make a fresh installation. In case you need both 32 bit and 64 bit follow this instruction: Stack Overflow - Install Oracle x86 and x64. If you have problems to uninstall Oracle, follow this instruction: How can I completely uninstall oracle 11g?


1

According to https://community.oracle.com/thread/959980 and https://community.oracle.com/thread/838380 the only way to do this is to use the SQLFILE parameter to impdp to create a script. Then replace CREATE PACKAGE with CREATE OR REPLACE PACKAGE and then execute the script.


0

I faced similar issue when i tried to drop materialized view it says View doesn't exist. If I try to create it, it says Name already exists. This is a bug in Oracle. Before dropping view, query on all_objects table. SQL : SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME ='MY_MVIEW'; It should return 2 records, ojbect_type = TABLE and Object_type = MATERIALIZED ...


1

What the SIDs on all the nodes? Is this really the same DATABASE. For example you can have 3 node cluster having a single ASM on all the nodes, but database A is clustered on node1/node2. But database B runs only on the node 3. The database B then is still started and stopped by the Clusterware, but is not clustered. You can also check output from: ps -ef ...


1

My best and most speculative guesses are: A lookup table. Used as a control/pick list for an application or report A dimension. Used in a data warehouse. A log table. Used for logging. Left over junk fron an adhoc query, data migration, report filter etc. Aaron was right... But I couldn't resist ; ) To me, the names imply that it's to distinguish ...


0

Use sql*loader to load the data : http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_params.htm#sthref540 (or external tables). 1) setup a .ctl file with your file format 2) setup / point to a receiving table in your database. 3) invoke sql*loader (sqlld)


0

This is not possible as the listener just handles the initial connection between the client and the database - so the database doesn't know anything about it. So anyways there at least two ways to get the path Looking at the default locations (i.e. $ORACLE_HOME/network/admin) fire up the OS-Command "lsnrctl status" and grep the path out of the output


1

The listener is an independent entity, can run from a different Oracle Home or even another machine. All the database knows about it is its address.


0

Yes, you will need Oracle Advanced Security to be installed. See http://docs.oracle.com/cd/E25054_01/network.1111/e10746/asointro.htm#i1008433 However a license for Oracle Advanced Security is no longer needed with 11g Release 2, but you will apparently need a license for "Oracle Identity Management Directory Services Plus". See PDF page 10 of ...


2

SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production ...


1

There is sys_context function that works for Oracle 12c select SYS_CONTEXT ('USERENV','ORACLE_HOME') from dual; This does not work for lower versions of Oracle. For 11g and lower versions, I don't know a simple method. PS: I read @Balasz' answer and now I know a simple answer for version 11g.


0

impdp SCOTT/password directory=DUMPDIR dumpfile=fromuser.dmp logfile=impdp.log remap_schema=SCOTT:DEV_LOCAL FULL=YES DEV_LOCAL will be the local empty schema that you should create!


0

The best way to enforce uniqueness in this scenario then is to not split the artist "types" into separate tables. Normalizing your schema will show that there are fields in common, so at the least your artists table would contain id, artist_type ("band" or "singer"), and name. Any fields that are not shared should be split into more generalized tables. ...


0

Yes, following the backup output: RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 10 Full 1010.57M DISK 00:00:48 02-APR-15 BP Key: 10 Status: AVAILABLE Compressed: NO Tag: ...


0

In my case i changed the host ip in /etc/hosts file but there was a hosts.swp file locking that change. So Listener was not coming up with the error "Linux Error: 111: Connection refused" used "vim -r /etc/hosts" to recover the change to the file, corrected it again clearly, then Listener came up


0

From the very first lines in the Oracle Documentation about Flashback Database feature ( https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta023.htm#RCMRF194 ): This command works by undoing changes made by Oracle Database to the data files that exist when you run the command. Flashback its mean to undo logical changes in the database. A ...


2

You mentioned AWR, so you are licensed to use ASH also. You can find the session(s) executing the specific SQL in DBA_HIST_ACTIVE_SESS_HISTORY view based on the sql_id. The PLSQL_ENTRY_OBJECT_ID and PLSQL_ENTRY_SUBPROGRAM_ID columns contain information about the PL/SQL call stack. This however may not be complete if you have several levels of PL/SQL ...


3

This online compression is extra cost option. And moreover usually online compression has worse compression ratio, then offline one. It's because the 1st one work on row level while the latter one works on block level. So if you really want to spare some space in the database and your old data are mostly read-only you should use: ALTER TABLE table_name MOVE ...


0

You can rebuild the indexes after or use the WITH UPDATE INDEX when executing your statement. E.g. ALTER TABLE table_name MOVE COMPRESS FOR ALL OPERATIONS WITH UPDATE INDEX; Note. Your statement will not compress existing data: only future data inserted.



Top 50 recent answers are included