oracle – datapump Imports – Database Administrators Stack Exchange

I am trying to do an import using data pump, but I am struggling to come up with the right options. The export was taken as a schema export. I am trying to import just the tables, with no other database objects.

I am currently using

INCLUDE=TABLE
TABLE_EXISTS_ACTION=REPLACE
REMAP_SCHEMA=
REMAP_TABLESPACE=

This is correctly importing the tables, but I am a little surprised to see that the import is also creating the constraints and triggers on the tables, or trying to at least. The triggers are failing because they include a schema name that does not exist in the database.

I thought that by using INCLUDE=TABLE only the tables would be included. Apparently that is not the case. I am unable to use EXCLUDE=CONSTRAINT or EXCLUDE=TRIGGER as I am already using INCLUDE to limit the import to just tables.

Any ideas on how I could structure the import to only import tables?

pathfinder 2e – Can a Battle Oracle take the Marshall dedication?

Nothing in the rules for Archetypes clarifies whether the prerequisite is meant to be “trained in all martial weapons” or “trained in at least one martial weapon”.

I, personally, think that the prerequisites are not fulfilled

Looking at various classes like Fighter or Barbarian, we see that they use the exact formulation of “Trained in martial weapons”, the exact same words used by the Archetype prerequisite. As a battle oracle, you are not trained in Martial Weapons as a whole, but instead would write down “trained in Weapons in the ‘Axe’ group” or “trained in Flail, trained in Combat Grapnel, trained in […]”. Which to me means you are not, in fact, “trained in Martial Weapons”.

In conclusion: You would need to ask your GM or come to your own conclusion if you are the GM

The answer is not clear at all, and I can see how people might not be on the same page as I am here. So your best bet is to ask your GM, or decide for yourself if you are the GM. Personally, I don’t really think there would be any balance concerns if you were to allow it, as the requirement could easily be met with a general feat.

query performance – Read explain results from oracle database

In operation 21, the optimizer estimates 58 rows to be returned from table TTAMSHIFTDAILY.

Using these 58 rows, in operation 22, the database will access index IX_TUNED_TTADATTENDANCE_1 58 times, estimating 1360 rows to be returned. But that is not the total amount of rows it expects to return, because it is a nested loops join. That estimate is about 1 iteration of the loop.

So in operation 20, the optimizer estimates 58 * 1360 = 78880 rows to be returned.

Then the optimizer estimates 1962 rows to be returned from VIEW_ATTENDANCE, because the above is joined to TTADATTENDANCE as well.

But these are just estimates, not actual values. Also, this plan is an adaptive plan (as displayed in the Notes section), so some of the lines are not even displayed in the current output. You can add the format=>'adaptive' parameter to your DBMS_XPLAN call to display the full plan.

oracle – Connect Application with separate DB links from same server

My application is connecting to our internal Oracle Server. Our internal Oracle server connects with a third-party server using a DB link. Now, our internal oracle needs to create another DB link to second third party. So our application currently we have,

Application >> connects to internal Internal:SomePort >> connects to third-party ThirdPartyIp:SomePort(via DB link)

Now, all our queries (from the application) are without @DbLink

Now we have created a new DB link on the same internal server,

Application >> SameInternalServer >> connects to another third-party ThirdPartyIp:SomePort(via DB link)

Is it possible to use different connection strings for different third party DB? or we will be struck to @DbLink syntex from the application?

For Third Party, we can use,

select * from ThirdPartyTable

But for the second we have to use,

select * from ThirdPartyTable@DbLink

Any way to mitigate avoid @DbLink because we have DB structure is same for both third-party servers.

oracle – View to check for spaces or zeros in all columns in all tables

I have a schema in a mapping system that has dozens of tables with columns that have incorrect values:

  • Number columns where the value is zero, but it should be null.
  • Text columns where the value is a space, but it should be null.

I would like to create a dynamic view that users could open in the mapping software that would return a list of columns that have incorrect values:

table_name    column_name    datatype    value    count
—————————————————————————————————-————————————-———————-
roads         width          number      0        500
sidewalks     description    varchar2    (space)  10000
Sidewalks     const_year     number      0        10  

(If the datatype, value, or count columns are difficult or inefficient to generate, I could live without them. I really just need a list of tables and columns that have bad values.)

What would it take to create a view like this in Oracle?

¿Cómo recuperar el valor de una clave la cual contiene un cadena de caracteres clob (demasiado grande) con JSON PL Oracle?

hola estoy trabajando con JSON PL, mi pregunta es ¿Cómo recuperar el valor de una clave la cual contiene un cadena de caracteres clob (demasiado grande) con JSON PL Oracle?

–LOGICA DE JSON

lnu_archivos := JSON(JSON_LIST(ljs_resp.GET('archivos')).GET(1));

IF(lnu_archivo.exist('imagen') AND lnu_archivo.exist('nombre')) THEN

   ---esta clave contiene un valor número muy gran de caracteres
   lvc_img := lnu_archivo.GET('imagen').GET_STRING();
   lvc_nomImg := lnu_archivo.GET('nombre').GET_STRING();

END IF;

authentication – Enabling TLS and TLS-MA simultaneously for different clients of a Oracle DB

We have a requirement where we want to enable TLS-MA for some of the clients connecting to a specific Oracle database while the other clients can continue to use TLS with server certificate.

  • We are using Oracle 12.c in our environment.
  • Clients are connecting using the jdbc thin driver

I am an Oracle noob and i am not able to understand the documentation here

Will it work if i create 2 listeners; one with
SSL_CLIENT_AUTHENTICATION=TRUE
and another with
SSL_CLIENT_AUTHENTICATION=FALSE

oracle – How to pass OFFSET and LIMIT to Function

I have one problem which a little bit confusing me. I want to create function which will display all products and limit 20 products per page and OFFSET = (page – 1) * 20.
So far what I try to create something like this

FUNCTION TEST_FUNCTION(p_limit IN NUMBER,p_offset IN NUMBER)
    RETURN SYS_REFCURSOR IS 
    rc  SYS_REFCURSOR;
BEGIN
OPEN rc FOR   
     SELECT * FROM 
      (SELECT i.*, (SELECT COUNT(*) FROM invoices) AS numberOfRows 
    FROM invoices i ORDER BY Id DESC)
    OFFSET = p_offset ROWS FETCH NEXT p_limit ROWS ONLY;         
RETURN rc;
END TEST_FUNCTION;

Here is problem which I get error

Error(125,12): PL/SQL: ORA-00933: SQL command not properly ended

So I want to pass two variable in my function LIMIT and OFFSET but since I pass OFFSET I get error message.
So far I found a couple of answers here, but whatever I try I get error message, it seems like I couldn’t pass OFFSET as variable.
Does anyone know any solution for this problem ?

redhat – Problem installing Oracle 19c to symlinked directory from RPM

I’ve created destination directory and linked it to default install path:

$mkdir /u01/oracle
$ln -s /u01/oracle /opt

Then I’ve changed the owner:

$sudo chown -R oracle:oinstall /opt/oracle

But when I tried to install RPM I got an error:

$sudo rpm -i ./oracle-database-ee-19c-1.0-1.x86_64.rpm
warning: ./oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

(SEVERE) The install cannot proceed because ORACLE_BASE directory (/opt/oracle)
is not owned by "oracle" user. You must change the ownership of ORACLE_BASE
directory to "oracle" user and retry the installation.

error: %prein(oracle-database-ee-19c-1.0-1.x86_64) scriptlet failed, exit status 1
error: oracle-database-ee-19c-1.0-1.x86_64: install failed

How to properly fix this problem?

insert trigger in sql server to linked oracle

i have created a linked server to oracle in sql server and i want to write one trigger on table in sql server to insert the data into oracle table. For example the table a is in sql server and table b is on oracle. If i insert record in table a the values needs to be copied or inserted into table b of Oracle.
both the tables have same structure

table a
id varchar2(10);
name varchar2(10);

table b
id varchar2(10);
name varchar2(10);