Best Of

Re: how to grant table from database to another database

Access the Table via the Database Link:

To allow a user in another database to SELECT from a schema (let's say schema_name.username) in your database, you typically use database links and object grants in Oracle.

On the target database (the one from which you'll be running queries), create a database link to the source database.
CREATE DATABASE LINK example_link
CONNECT TO username IDENTIFIED BY password
USING 'tns_service_name';
Grant SELECT Privileges
On the source database (where schema.username exists), grant SELECT privileges on the desired tables or views.

GRANT SELECT ON schema.table_name TO username;

Access the Table via the Database Link

SELECT * FROM schema.table_name@EXAMPLE_LINK;

Somashekar-Oracle

1

Re: Two PO's released by the Plan with Same Need by Date on same creation date.

Hi @User_ID376 ,

It is not possible to ascertain the exact reason why two rows are released once the planned orders are released and the plan is re-run. All the details related to the previous planned orders are re-written.

Having said that, these kind of issues happen due to PTF or movement of planned orders due to constraints. In the above scenarios, though the planned orders are originally created at different dates, they might be moved to same date and got released.

The only way to ascertain the cause is to review the plan output on the very same day when the planned orders are released (or before the plan is re-run).

Hope the above helps!

Best Regards,

Mohan Balaji

Mohan Balaji Chimakurthy-Oracle

1

Re: About statistics on PDB$SEED before upgrade

Yes and if you do, don't forget to mention the answer to the core question of this thread, whether or not you should open the Seed container in write mode. And, if you even can. I think you shouldn't because Seed is Seed … But then you must have a look why this is wrong as it is. Maybe it is just a trailing action because of some earlier upgrade ?

Mr. C

1

Re: Concurrent Program PRC: Transaction Import

Hi Gene,

You should enter the entire value displayed in the Name field (i.e. '340-HUMAN RESOURCES').

The validation on the organization_name field is: Must be a valid organization in
PER_ORGANIZATION_UNITS.NAME

Thank you!

Sherry

SherryG-Oracle

1

Re: How to pull P6 baseline project activities details from P6 using rest api

@Michael Hilferty-Oracle and @DavidCumming : Thanks for reply and your efforts in looking into this, our current P6 version is 25.4 and its Cloud.

Also, I have found the way to pull this information from rest API and is as below:

From Project End Point, pull below fields:

Name,Id,ObjectId,CurrentBaselineProjectObjectId

And then in Activity End Points, pull requested information with Activity id i.e. , Early Start, Early Finish etc. and pass the filter for ProjectObjectId with value "CurrentBaselineProjectObjectId" received from Project EndPoint.

User_JI7IB

1

Re: oracle system one sql run too long time

Just to emphasise the point the Bruno made - I have a partitioned table called pt_range with 3 partitions, which happens to have a local index called pt_range. Here's the output from your query (reduced to a subset of the columns) when I specify my schema name and the table name, plus a non-null :object_type and null :sub_object

TABLE_NAME                OWNER             OBJECT_NAME          OWNER             OBJECT_TYPE             COMMENTS
------------------------- ----------------- -------------------- ----------------- ----------------------- --------------------------------
PT_RANGE                  TEST_USER         PT_RANGE             TEST_USER         TABLE                   This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         TABLE PARTITION         This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         TABLE PARTITION         This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         TABLE PARTITION         This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         INDEX                   This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         INDEX PARTITION         This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         INDEX PARTITION         This is a partitioned table
                          TEST_USER         PT_RANGE             TEST_USER         INDEX PARTITION         This is a partitioned table

8 rows selected.

Note that the query has picked up the table and its index and the partitions of the table and index. And the comment that's been reported 8 times is the comment associated with the table.

And this is the result running Bruno's query (with the typo - the extra "join" - deleted and, again, a subset of columns):

TABLE_NAME                OWNER             OBJECT_NAME          OWNER             OBJECT_TYPE             COMMENTS
------------------------- ----------------- -------------------- ----------------- ----------------------- --------------------------------
PT_RANGE                  TEST_USER         PT_RANGE             TEST_USER         TABLE                   This is a partitioned table

1 row selected.

Regards

Jonathan Lewis

1