Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: dblink

Postgresql MVIEW refresh from Oracle Materialized View Log

By adminPosted on January 14, 2023

Question : Is it possible for me to have Oracle MVIEW log in my source database and refresh a Postgresql […]

Connecting Oracle 11g to Postgres via dblink

By adminPosted on January 9, 2023

Question : I have administrator access to our Oracle database , but was wondering if its possible to connect an […]

How to Oracle DBLink encryption

By adminPosted on January 8, 2023

Question : I have the environment that I explain below and I need to encrypt the data that is sent […]

Can I use postgres_fdw without foreign tables defined?

By adminPosted on December 22, 2022

Question : I have a production database “PRODdb1”, with a read-only user account. I have a need to query(select statement) […]

Alternatives for Dblink in oracle?

By adminPosted on November 1, 2022

Question : we have an SSIS job that inserts data into a table in server A from data in table […]

Unable to access tables in sql server using oracle dblink

By adminPosted on October 18, 2022

Question : I have created a Heterogeneous connection between oracle and sql server. and tested with below query, SELECT * […]

What is a DB Link good for? [closed]

By adminPosted on September 17, 2022

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Oracle 12c – Create materialized view results in ORA-00942

By adminPosted on September 8, 2022

Question : I have a view that I can access through a database link as such: SQL> select count(*) from […]

Results of SAMPLE clause using a DBlink between 2 Oracle databases not randomised

By adminPosted on September 4, 2022

Question : I’m using the SAMPLE clause to retrieve random rows from a table. It works fine except when the […]

Issue with Identifiers in Postgres greater than Oracle’s limit while connecting over ODBC (DBLINK)

By adminPosted on April 13, 2022

Question : We have a database link from Oracle 12.1 to Postgres via psqlODBC Driver. There is a problem while […]

  • 1
  • 2
  • 3

Recent Posts

  • Get column names and data types of a query, table or view
  • What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?
  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding