Which tables are partitioned? Which tables are index organized?

This requirement calls for reporting…

Start Search by right-clicking the physical model name in Browser and by selecting Search.

Fig1

Select Advanced Mode and select Table as Object Type.

Fig2

Press Add Property.

Select Partitioned as a Property and type “yes” to the value field.

Fig3

Press Search.

Fig4

Now you have a list of partitioned tables in physical model Oracle 12c.

Maybe you want to have a nice report of them?

Press Report.

Fig5

You can generate the report as it is

Fig8

or you can use Custom Templates.

Fig6

Fig7

How about my IOTs?

In Advanced Mode select Organization as Property and type “Index” on value field.

Fig9

Press Search. Press Report. And either generate the report as is or use one of your Templates.

Fig10

Fig11

And if I want to have tables that are both partitioned AND index organized?

Fig12

First select Partitioned=yes. Then press Add Property again and select Organization=index. Remember to set the logical operator to AND. Then press Search.

Fig13

And generate the report wanted.

Note: If you run the report in Microsoft Excel format you are able to edit the content in Excel and then upload it back to Data Modeler.

Fig14

BGOUG, thank you!

It is easy to say BGOUG is one of my favourite conferences. Not only because Milena is a dear friend, the venue is always wonderful, food is excellent etc but because I simply love the Bulgarian audience! They are extremely interested in learning, they ask a lot of questions and the best for a shy Finn like me is that they give you wonderful face-to-face feedback.

After my first session a gentleman came to me and he said he saw my session two years ago and it changed his life for better: now he knows a better way to talk to the end users to get better requirements to be able to create better databases and applications for end users. Another person came to me and said he really hope I will be there in November to share my knowledge again because he learns so much in every presentation. A lady wrote to me that she admires my work and enjoys my sessions very much. Etc.

I am usually very bad with feedback: good or bad. But these people can give it in a way I do not feel embarrassed but honored and privileged. Thank you all for your nice comments! You do not know how much it means to me! I was really tired after the conference (I just realized I have not had any free weekends for two months!) but extremely happy: my travelling and speaking has a meaning! Thank you!

And Thank you Philip Stoyanov for the fantastic speech!

Heli

Closing the FY

It’s the end of Oracle fiscal year and now it’s time to close the books for that fiscal. I did have a busy year. I wrote my first book

http://www.mheducation.co.uk/9780071850094-emea-oracle-sql-developer-data-modeler-for-database-design-mastery

I attended two OTN Tours. I had four sessions at the Oracle Open World, I taught the first time at the OU Expert Summit and much more. And being honest I was very sick for 4 months so I actually only had 8 months to do that all 🙂 I spoke in (at least) these events:

21.-26.5.2015 OTN EMEA Tour: Portugal, Jordan, South Africa

16.5.2015 Wildcard Unconference, Riga, Latvia

23.4.2015 Oracle University Expert Summit, Bucharest, Romania

22.4.2015 RoOUG, Bucharest, Romania

12.-14.3.2015 OUGN, Norway

22.1.2015 Riga Dev Day, Riga, Latvia

18.–20.11.2014 DOAG Deutsche ORACLE-Anwendergruppe e.V., Nüremburg, Germany

13.11.2014 Oracle Roadshow, Turku, Finland

6.11.2014 Oracle Roadshow, Espoo, Finland

28.10.2014 Oracle Roadshow, Tampere, Finland

20.- 23.10.2014 Nordic ACE Director Tour: Sweden, Norway, Denmark, Finland 28.9.–2.10.2014 Oracle OpenWorld, San Francisco, USA

22.-26.6.2014 KScope14, Seattle, USA

13.-15.6.2014 BGOUG, Bulgaria

5.-6.6.2014 Harmony, Finland

20 events… wow! But I did have a wonderful year and I enjoyed every moment of it. Thank you for inviting me to speak in those amazing events and thank you OTN and the ACE program for funding many of my tours! Thank you Oracle Press for asking me to write the book.  I wonder what will happen this year…

BGOUG, Day 2

It’s the second day of BGOUG conference. The first day was excellent and was highlighted by a great party in the evening: good food and drinks, great company and lots of dancing! Not to mention the nice speech Philip Stoyanov gave at the party before we had a raffle for two lucky winners for a copy of my book 🙂

The second day started with a breakfast at 8 and the sessions at 10. I have been working the whole morning (answering questions from customers about Data Modeler, preparing my sessions etc) and I just realized that while you are travelling you do not make a difference if the day is a weekday or Saturday/Sunday. It’s 11.30 am now and I was wondering why people do not reply my emails. Now I know: it’s Saturday 🙂

Today I will have two sessions: one about comparing designs and database (at 14:00) and another one about reporting (at 15:00). Both sessions are in Plovdiv 3. I hope to see you there!

Cheers,

Heli

Oracle SQL Developer Data Modeler for Database Design Mastery available in EMEA!

My book is finally available in EMEA:

Amazon
http://www.amazon.co.uk/Oracle-Developer-Modeler-Database-Mastery/dp/0071850090/ref=sr_1_1?s=books&ie=UTF8&qid=1434007533&sr=1-1&keywords=9780071850094

M-H Education EMEA
http://www.mheducation.co.uk/9780071850094-emea-oracle-sql-developer-data-modeler-for-database-design-mastery

ilOUG Tech Days 2015

Tomorrow it starts: the ilOUG Tech Days 2015 in Haifa, Israel. I travelled all day yesterday to be here in time to attend the fantastic guided tour by Ika, the best guide in Israel. We had a wonderful day at the Nazareth area. After the tour I needed to work a little and then to dinner. Then I prepared my slides for tomorrow. I will be talking about agile database design, reporting with Data Modeler and about database security. And I will give one copy of my new book away in each Data Modeler session…

Hope to see you tomorrow! Now it’s time to go to bed…

Why does my Data Modeler look different from yours?

There is still some confusion on different appearances of Oracle SQL Developer Data Modeler. I hope this will explain a bit.

There are two different appearances of Data Modelers: the one integrated in Oracle SQL Developer and the standalone Data Modeler. And they do look different and using them is different. If you want to design the databases I would recommend the standalone version. I would use the integrated version mainly as a viewer to Data Modeler.

Integrated version:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index-097090.html

Standalone:

http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

The #EOUC2015 in Lisbon

I just got back from the EMEA user group leaders’ meeting in Lisbon. It was so great to see so many amazing friends again!

During the meeting we for instance agreed on the Ambassador program (DOAG and UKOUG will organize the election for new Ambassadors pretty soon) and the new and improved way of counting votes for the OOW when we select our EOUC speakers. I posted about these to Oracle community platform.

I hope I will have time later to blog more about the meeting. Unfortunately my pictures are not very good so cannot share them 😦

Now back to work. On Sunday I will fly to ilOUG and so much work I must finish before that…

The third leg of the #OTNEMEA Tour, South Africa

The third and last event of our tour was Johannesburg, South Africa. The event was held at the local Oracle office which BTW is very beautiful. There have been some major changes in the organization of the local user group, SAOUG, but now it’s up and running again and the new president gave a nice welcome speech to kick off the event.

First I gave my presentation about “Getting started with Oracle SQL Developer Data Modeler” added with some general things from my “Database Design with Oracle SQL Developer Data Modeler” session. Later the day I gave a presentation about “Reporting with Oracle SQL Developer Data Modeler”. And of course I gave away one of my books, this time to Dina. This copy is special because it’s also signed by Debra Lilley who has written some nice words in the beginning of the book.

The local Oracle was kind enough to serve us a lovely lunch which was needed because we did overrun, we finished much later than planned.

It was a great tour! Thank you user groups in Portugal, Jordan and South Africa! I hope you liked my sessions and learnt new things about Data Modeler. Thank you Björn for organizing and OTN for funding the trip! And especially thank you to my travelling friends: Debra, Björn and Tariq. I sincerely hope this tour will be organized next year again and please consider me as one of the speakers 😉