DBA Blogs

Materialized View Partitioned

Tom Kyte - Fri, 2017-03-31 12:06
Hi, I would like to know about two situations: 1)my base table is not partitioned and i have a materialized view on the same. Is it possible to partition the materialized view. If yes kindly provide steps for the same. 2)I have a table whic...
Categories: DBA Blogs

Big Announcement – New Job, New Country (A New Career In A New Town)

Richard Foote - Fri, 2017-03-31 08:45
After 5 1/2 years at Oracle Corporation, I’ve decided to leave and take on a very exciting new challenge !! President Trump’s office have accepted my nomination to head their IT department in Washington DC, where I’ll be responsible for ensuring all USA government data is stored in a extremely efficient and secure manner. So secure, that […]
Categories: DBA Blogs

Oracle GoldenGate 101 at IOUG 17 and GaOUG TechDays 17 within two month

DBASolved - Fri, 2017-03-31 08:00

Losts have changed for me since my last blog post. A new job and new responsibilities, which will include presenting more at conferences on the conference circuit and a few roadshows that are planned in the near future.

Back in the fall of 2016, when most of the Call for Papers open, I had a great idea for introducing people to Oracle GoldenGate. This idea is walk everyone through the progression of replication technology from CDC through Oracle GoldenGate, including some future road map items; that will ensure Oracle GoldenGate stays the number 1 replication tool on the market.

Over the next two months, I will be presenting this great idea/topic in a presentation called Oracle GoldenGate 101 – Replication from the beginning starting at IOUG Collaborate next week (April 2-6, 2017) and then at the best keep secret in the south – Georgia Oracle User Group (GaOUG) Tech Days 17 on May 9th-1th, 2017 (register here). This is going to be a session you will not want to miss, espeically if your organization uses Oracle GoldenGate for any architecture.

Additionally, the great guys who run the Georgia Oracle User Group (GaOUG) have done some amazing things since the planning of Tech Days 17 started. Just getting the key note speaker was a great addition to the already packed schedule of talks. This year, the keynote speaker is Maria Colgan, Master Product Manager for Oracle. She will be sharing some new and exciting items related to the Oracle Database and the direction Oracle is taking with new and exciting products.

GaOUG will also have dozens of Oracle ACE’s and ACE Director’s talking about topics accross multiple track (Database Development, Big Data, Applications, Middleteir). As an added bouns this year, GaOUG has added a half day Cloud track where you can learn all the items needed for your future Cloud deployments.

Hope to see everyone at both of these events, especially GaOUG in the coming months!

If you want to learn more about GaOUG Tech Days and the other impressive speakers, check out the blog hop posts below! What is a blog hop? It’s a group of bloggers who all get together to blog on a similar topic, giving you a lot of useful information from different perspectives, but in one stream. Enjoy your “hop” between blog posts and register for GaOUG Tech Days today!

Stewart Bryson
, RedPill Analytics
Jim Czuprynski, OnX Enterprise Solutions
Chris Lawless, Dbvisit Software
Danny Bryant, Accenture Enkitec Group
Eric Helmer, Mercury Technology Group


Filed under: GaOUG
Categories: DBA Blogs

Removing duplicates in a parent child connect by path

Tom Kyte - Thu, 2017-03-30 17:46
Hi Tom, I have the code below which seems to do the job ok. I was wondering however if there's a more elegant way using analytics or other methods to come up with the same results in a more dynamic way that would factor in the level becoming 5 for...
Categories: DBA Blogs

SQL ERROR, ORA-00984: column not allowed here

Tom Kyte - Thu, 2017-03-30 17:46
I'm taking a course using SQL for the first time and while following my instructors instructions exactly as he told us to, I keep getting the error that a "column is not allowed here". I created a table called Employee like this: <code>CREATE T...
Categories: DBA Blogs

Kindly suggest how many modules in Oracle DBA and suggest best to become best DBA associate

Tom Kyte - Thu, 2017-03-30 17:46
Dear Colleague, I am manoj sai subbarao, from india hyderabad and currently working as trainee junior data analyst in data operations in production side having on hands experience on oracle database from one year and having sound knowledge in O...
Categories: DBA Blogs

Migration from 11g to 12c

Tom Kyte - Thu, 2017-03-30 17:46
We are migrating from 11g to 12c. We need to the object coverage (Oracle dependencies), as we external applications (mainly Java applications) calling our Oracle package, function procedures. So what is best way to find calling hierarchy whi...
Categories: DBA Blogs

rename datafile with dummy characters after .dbf

Tom Kyte - Thu, 2017-03-30 17:46
<i>Hi tom, i've run into an issue out of the ordinary. while adding datafile to an existing tablespace we had fews trailing characters inbedded (by mistake) at the end of the .dbf extension. We have dbvisit replication broken due to this since...
Categories: DBA Blogs

Information Technology Jobs Posted

Bobby Durrett's DBA Blog - Thu, 2017-03-30 10:15

My company, US Foods, has posted a number of information technology jobs that are in Chicago (Rosemont)  or Phoenix (Tempe). Here is the web site:

https://usfood.taleo.net/careersection/usf_external/jobsearch.ftl

Enter Information Technology as the Job Field to see all the posted IT jobs.

Bobby

Categories: DBA Blogs

Links for 2017-03-29 [del.icio.us]

Categories: DBA Blogs

Convert the varchar vaules into number

Tom Kyte - Wed, 2017-03-29 23:26
Hi Tom, I am created the column "seqnum" as varchar2 . I need to show the values are order by ascending while selecting the values 100_1 10004_3 1002_21 123_2 10_45 2_3 10004_1 10004_5 I need to show the results as 2_3 10...
Categories: DBA Blogs

Table configuration

Tom Kyte - Wed, 2017-03-29 23:26
Hi Tom, Below is two tables where initial data will be near 47 Millon and all foreign table data will max 10000 thousand ,then per day transaction will be 1 millon. Is my below structure is ok or need some changes to support this process?Also I ...
Categories: DBA Blogs

Very slow queries after nightly statistics gathering job runs

Tom Kyte - Wed, 2017-03-29 23:26
We have an application that loads data from files and runs validation queries on the loaded data. We have observed very slow validation queries on the first file loaded after the nightly statistics job has run (and cleared all of the plans for the ta...
Categories: DBA Blogs

SYSTEM Tablespace-a second datafile

Tom Kyte - Wed, 2017-03-29 23:26
Hi, Is it possible to add a second datafile to a SYSTEM tablesapce of database, when this tablespace is almost full with few bytes free. (This tablespace is AutoExtensible with Unlimited Maxbytes and Maxblocks) Appreciate your response ASAP ...
Categories: DBA Blogs

Is PGA memory allocated from SGA ?

Tom Kyte - Wed, 2017-03-29 23:26
Hi Tom, Is PGA memory allocated from SGA? In my database SGA_MAX_SIZE is 1504M SQL> sho parameter sga_max_size NAME TYPE VALUE ------------------------------------ ----------- ----------------------...
Categories: DBA Blogs

Display all dates data of a given period name

Tom Kyte - Wed, 2017-03-29 23:26
Hi Tom, I need to pass a gl period_name eg.:-('JAN-17') to the query and get sum of debit and credit hit to each and every account. But here a problem is that I also need to display the output of any date which is not having the data. If an...
Categories: DBA Blogs

Security Monitoring and Compliance

Oracle is introducing two new security cloud services, built upon Oracle’s secure unified big data platform, the Oracle Management Cloud. Oracle Management Cloud (OMC) is a is a suite of...

We share our skills to maximize your revenue!
Categories: DBA Blogs

pl/sql code debugging - long running block

Tom Kyte - Wed, 2017-03-29 05:06
hi - our developers have a package that they are running within a begin... end block. They are telling us that this block seems to run for a very long time. this is the only thing that is running in the database and using over 90% of cpu. we ran the ...
Categories: DBA Blogs

equivalent of DBMS_XMLGEN.GETXML to generate json

Tom Kyte - Wed, 2017-03-29 05:06
We are currently generating XML data based on DBMS_XMLGEN.GETXML() to send it to client. Instead of xml , we want to send data as JSON. Is there anything similar to DBMS_XMLGEN.GETXML to generate json ?
Categories: DBA Blogs

Extents Tablas Oracle

Tom Kyte - Wed, 2017-03-29 05:06
Tom, because when I create a table with the following values ??in each of its partitions, I generate 195 extents? If the partitions have an INITIAL if the size of the partition. COMPRESS BASIC STORAGE ( INITIAL 7748954362 - 7.2 GB NE...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs