Tag Info

New answers tagged

0

According to the Oracle 11g documentation, SYSTEM and SYSAUX tablespaces are the mandatory tablespace. If you dont use automatic undo management then the UNDO tablespace is not required. You can use rollback segment in the SYSTEM tablespace. In summary, SYSTEM for Data Dictionary, SYSAUX auxiliary to SYSTEM is the default storage for the AWR statistics. ...


0

impdp is able to create the tablespaces. You can even change the location of the datafiles if needed. Check the documentation for more information since there are many parameters with this tool (REMAP_DATAFILES and REUSE_DATAFILES for example).


0

You can list them with this query (similar to sys.procedures): SELECT * FROM USER_PROCEDURES For execution count, I think you will have to use Audit functionnalities.


1

From the Oracle 11g Documentation: A datafile can be associated with only one tablespace and only one database. So you don't have to worry about losing data from another tablespace.


1

You could use multiple SELECT Statements, like this: SELECT CHT.ID, (SELECT SUM(TOTAL_E + TOTAL_F + TOTAL_STOC) FROM DEP_DEZ WHERE FK_ID_CHESTIONAR = cht.ID), (SELECT SUM(MASA_TOTALA) FROM CAR_EXP WHERE FK_ID_CHESTIONAR = CHT.ID) FROM CHEST cht GROUP BY CHT.ID


0

Don't get hung-up on "cloud" vs "local" - what you're doing is establishing a TNS network link between two databases. It is nothing more than that. In order to do this, you will need to have the appropriate tns entries configured in your tnsnames.ora (unless you are using LDAP or you pass in the entire connect string). If you don't know how to do this, the ...


0

That is not how you connect to another database through database links. Database links require SQL*Net connectivity, not HTTP(S). First you need to enable access, then you can connect using the address of the compute node and the service name for your database. ...


2

Bug 11872813 - V$PGA_TARGET_ADVICE VIEW IS EMPTY. After setting PGA_AGGREGATE_TARGET > approximately 12G the V$PGA_TARGET_ADVICE view is empty. This issue will be fixed in version 12.1 and a fix is expected to be included in patch set 11.2.0.4. Apply Patch 11872813


0

If you have duplicate inserts, the first question I would have would be why would you have two rows in the same table with the exact same information? That being said, if there are no unique keys or other such constraints on the table, the new DB server should dutifully import the duplicated data. I would heartily recommend testing it in a non production ...


0

You can also OR IN clauses. Such as: select count(*) from version where version_id in (1,2,3,4,5,...255) or version_id in(256,257,258,....);


-1

http://stackoverflow.com/questions/3142665/how-to-convert-csv-to-table-in-oracle Please check the above link. You can convert csv to table. Now, Let lets say you have a table tmpId_t Now join the two tables and change a little bit as per your need.


2

Try creating a temporary table to hold all of the IDs you want to search on then join in that temporary table. create table tmpIds(id int not null) insert into tmpIds (59156) insert into tmpIds (57045) etc... SELECT COUNT(*) FROM "VERSION" INNER JOIN tmpIds ON "VERSION"."VERSION_ID" = tmpIds.id drop table tmpIds



Top 50 recent answers are included